When tuning YSQL queries with EXPLAIN (ANALYZE, DIST), you will often notice that the first execution performs several catalog reads while later […]
Read More
Why Won’t pg_operator Cache in YugabyteDB?
YSQL catalog cache preloading can reduce the catalog reads performed when a new PostgreSQL backend processes its first queries. However, on older […]
Read MoreFind YugabyteDB Syscache IDs for yb_neg_catcache_ids
YSQL relies heavily on PostgreSQL’s system catalog cache, commonly called the catcache, to avoid repeatedly reading metadata from system catalog tables such […]
Read MoreUnderstanding 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 More