YSQL relies heavily on PostgreSQL’s system catalog cache, commonly called the catcache, to avoid repeatedly reading metadata from system catalog tables such […]
Read More
Understanding YSQL Catalog Caching in YugabyteDB
Distributed databases change the cost model of metadata access. In PostgreSQL, system catalog tables live locally on disk and are typically cached […]
Read MoreIdentifying 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 More