System catalogs, also referred to as system tables or system views, are essential to the internal structure and management of the database, […]
Read More
Load 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 MoreUse the YB_LOCAL_TABLETS Sytem View to Map Table Rows to their Tablets
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. […]
Read MorePresplit a Materilized View into a Specific Number of Tablets
For larger tables and indexes that are hash-sharded, we can specify the number of initial tablet splits desired as part of the […]
Read More