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
Reduce 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 MoreReduce Master Reads During YSQL Connection Churn with Authentication Caching
Applications that frequently open and close YSQL connections can generate more database work than the SQL being executed might suggest. Every fresh […]
Read More