We learned in the tip LIST THE SERVERS IN YOUR CLUSTER that in YSQL we can list the nodes (hosts) in our […]
Read MoreSet Statement Timeout to Avoid Runaway Queries
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 More