When a new YSQL backend session executes a query for the first time, PostgreSQL must read metadata from system catalog tables In […]
Read More
Bump the YSQL Catalog Version
Introduction In YugabyteDB, the catalog version is a small but critical number that ensures all nodes in a cluster are in sync […]
Read MoreFrom 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 More