YSQL uses PostgreSQL’s system catalog caches to avoid repeatedly reading metadata from the distributed system catalog. But there is another useful optimization […]
Read More
Reducing Cross-Region YSQL Catalog RPC Latency in YugabyteDB
In a multi-region YugabyteDB deployment, an application can be connected to a local YB-TServer and still occasionally experience cross-region latency during query […]
Read MoreDiagnosing a Persistent pg_range Catalog Read in YugabyteDB
When tuning YSQL queries with EXPLAIN (ANALYZE, DIST), you will often notice that the first execution performs several catalog reads while later […]
Read MoreWhy 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 More