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 MoreDeclarative Partitioning in YugabyteDB: Great for Data Purging… But Know the Trade-Offs
YugabyteDB supports PostgreSQL-style declarative table partitioning, including RANGE, LIST, and HASH partitioning. That can be especially useful for large tables where data […]
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