Many PostgreSQL statistics views are local to the PostgreSQL server process you are connected to. That matters in YugabyteDB because a cluster can […]
Read More
Verify pg_type Negative Catalog Caching in YugabyteDB
YSQL uses PostgreSQL’s system catalog caches to avoid repeatedly reading metadata from the distributed system catalog. But there is another useful optimization […]
Read MoreShow YSQL Catalog Table and Index Sizes in YugabyteDB
YSQL relies heavily on PostgreSQL-compatible system catalogs to store metadata about tables, columns, indexes, constraints, functions, statistics, schemas, users, and much more. […]
Read MoreReducing 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 More