In YugabyteDB, collecting up-to-date table statistics is critical when the cost-based optimizer (CBO) is enabled. These statistics guide the optimizer in choosing […]
Read More
Use PostgreSQL Command Line Tools for YugabyteDB
YugabyteDB is a distributed SQL database built to scale out while maintaining compatibility with the PostgreSQL ecosystem. That compatibility is not just […]
Read MoreAudit Selects on a Table to an Audit Table Using RLS
In PostgreSQL—and by extension, YugabyteDB—there’s no native trigger that fires on SELECT statements. This means we can’t use a traditional AFTER SELECT […]
Read MoreIdentifying and Removing Redundant Indexes in Your Database
Secondary indexes in YugabyteDB are critical for improving database query performance by allowing faster access to rows. However, like any tool, they […]
Read MoreCluster-Wide Catalog Table Query Aggregation
We learned in a previous YugabyteDB Tip that we can Consolidate Data From YB Catalog Tables From All Nodes To One Node. […]
Read More