Distributed databases change the cost model of metadata access. In PostgreSQL, system catalog tables live locally on disk and are typically cached […]
Read More
Identifying YSQL Catalog Tables to Preload – Without Grepping Logs Across Nodes
When a new YSQL backend session executes a query for the first time, PostgreSQL must read metadata from system catalog tables In […]
Read MoreBump 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 More