Sometimes a query result looks wrong at first glance… until you realize YugabyteDB is doing exactly what the type system told it […]
Read More
Terminate Idle Sessions in YSQL
In YSQL (Yugabyte Structured Query Language), idle sessions refer to database connections that remain open but are not actively executing queries. These […]
Read MoreDisplay YSQL Database Size
The Postgres pg_database_size(name) built-in system function retunrs the disk space used by the database with the specified name. Although YugabyteDB is Postgres […]
Read MoreUsing the Translate Function in YSQL
The translate() function in both PostgreSQL and YugabyteDB’s Postgres compatible YSQL API, does one-to-one translation of characters in a single operation. The […]
Read More