When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreCheck for Invalid Indexes in YSQL
If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read MoreConsolidate Data From YB Catalog Tables From All Nodes To One Node
🆕 Looking for the Built-In Approach? This Tip shows how to consolidate node-local YSQL catalog and statistics data using postgres_fdw. Starting with […]
Read MoreLoad Balance YSQLSH Connections
The ysqlsh CLI is the shell for interacting with the YugabyteDB YSQL API. The -h (or –host) flag specifies the host name […]
Read More