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
Find DML Hotspots in YugabyteDB: Row Skew vs. Activity Skew
When troubleshooting a write-heavy YugabyteDB workload, one of the first questions is often: Are my rows evenly distributed across the tablets? That […]
Read MoreReduce YSQL Execution Latency by Batching Multi-Row Point Lookups
This Tip is the second in a two-part series looking at the performance impact of large multi-column IN lists in YugabyteDB. In […]
Read MoreReduce YSQL Planning Overhead with Stable SQL and UNNEST
A multi-column IN predicate is a convenient way to perform a batch of point lookups: SELECT item_id, description, category_id, state_code, lookup_hash, version, […]
Read More