Introduction In YugabyteDB, the catalog version is a small but critical number that ensures all nodes in a cluster are in sync […]
Read More
From table_id to Table Name in YSQL
Not long ago, a Yugabyte Tip shared a neat trick: how to display a table’s table_id in YSQL by calling yb_table_id(oid) inside […]
Read MoreAvoid Cache Invalidation When Analyzing Tables
YugabyteDB’s cost-based optimizer (CBO) is a big deal. Turn it on, keep stats fresh, and your plans get smarter, closer to PostgreSQL […]
Read MoreExploring Catalog Tables vs. Extension Views in YugabyteDB
In PostgreSQL-compatible databases like YugabyteDB, the system catalogs are packed with metadata about tables, functions, privileges, and more. But not all system […]
Read MoreMonitoring YugabyteDB Catalog Table Sizes
YugabyteDB delivers the best of both worlds: horizontal scalability and global distribution, powered by a PostgreSQL-compatible query layer (YSQL). But even in […]
Read More