When designing for scale in YugabyteDB, we often think about pre-splitting large tables. But indexes matter too. In YugabyteDB, secondary indexes are […]
Read More
Fixing temporary file size exceeds temp_file_limit by Tuning the Query, Not Just the Limit
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 MoreTurning 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 MoreWhen Generated Columns and Indexes Turn a Simple JSONB UPDATE into a Distributed Write Amplifier
The the previous tip, Update JSONB the Smart Way with jsonb_set() and the || Merge Operator, we looked at two cleaner ways […]
Read More