postgres_fdw is incredibly useful when you need to query a remote PostgreSQL-compatible database from YugabyteDB. But there is one performance rule you […]
Read More
Finding Triggers That May Be Doing Hidden Work
Triggers can be easy to forget about. A query may look simple from the application side, but behind the scenes a trigger […]
Read MoreFixing 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 More