A YugabyteDB query can sometimes fail with an error like this: ERROR: temporary file size exceeds temp_file_limit (1048576kB) At first glance, this […]
Read More
Turning a Slow ORDER BY … LIMIT Query into an Index-Only Scan
A common tuning pattern in YugabyteDB is finding a query that looks simple, has indexes available, and still performs inconsistently. This often […]
Read MoreTemporarily Ignore Query Hints
A customer recently asked a great question: “Is there a session setting in PostgreSQL or YugabyteDB to make query hints ignored?” Yes, […]
Read MoreWhen Index Read Latency Creeps Up, Look Beyond Compaction
A slow query is not always just a “bad query.” Sometimes the query plan looks reasonable, the index is being used, and […]
Read More