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 MoreIdentify Tables without a Primary Key
In YugabyteDB, just like in PostgreSQL, the YSQL API doesn’t require a primary key when creating a table. However, because YugabyteDB distributes […]
Read More