In the previous tip Why Your Index Scan Still Reads Thousands of Rows, the second in our index tuning series, we saw […]
Read More
Why Your Index Scan Still Reads Thousands of Rows
Common questions engineers search for: ● Why is my indexed query still scanning thousands of rows? ● Why does PostgreSQL / YugabyteDB […]
Read MoreHow 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 More