Common questions engineers search for: ● Why is my indexed query still scanning thousands of rows? ● Why does PostgreSQL / YugabyteDB […]
Read More
How to Choose the Right Column Order in an Index
Introduction Designing an efficient index is one of the most important skills for optimizing SQL queries. Many developers know that indexes improve […]
Read MoreIdentifying YSQL Catalog Tables to Preload – Without Grepping Logs Across Nodes
When a new YSQL backend session executes a query for the first time, PostgreSQL must read metadata from system catalog tables In […]
Read MoreHandling Variable-Length IN (…) Clauses with pg_hint_plan in YugabyteDB
Sometimes you need to force a specific query plan, even when the query includes an IN (…) list whose length changes at […]
Read More