If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read More
Consolidate 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 MoreNavigate Wide Query Output in YSQLSH Using Your Left and Right Arrow Keys
Using ysqlsh and annoyed by wrapping lines creating difficult-to-read outputs? Try setting the PAGER environment variable, when starting ysqlsh (then you’ll be […]
Read More