Suppose your YugabyteDB universe spans three regions. You’ve ranked one region as the first choice for tablet leaders and the others as […]
Read More
When Bad Queries Turn Into Big Bills: Filter Pushdown in YugabyteDB
A query returns a relatively small number of rows. It runs only every few seconds. How bad could it be? In a […]
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