In YSQL establishing a statement timeout via the statement_timeout parameter restricts queries from exceeding a designated duration. This timeout can be configured […]
Read MoreSuppress the Advisory Lock not implemented error in YSQL
PostgreSQL provides a means for creating locks that have application-defined meanings. These are called advisory locks, because the system does not enforce their use […]
Read MoreSimulate Synonyms in YSQL
If you’ve worked with the Oracle database you know that a synonym is an alias for a schema object such as the tables, […]
Read MoreErase Statistics
The ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. These […]
Read MoreStoring Pictures (i.e. JPGs) in YugabyteDB
There’s an age old question asking is it better to store images offline in a file system or online inside a database […]
Read More