Speeding up things with hint bits
UPDATED June 2023: What are hint bits in PostgreSQL? Hint bits improve PostgreSQL performance - find out why and how. Includes code examples.
Optimization issues: Cross column correlation
UPDATED Sept. 2023 - A couple of years ago I stumbled over an interesting PostgreSQL issue which is commonly known as “cross correlation”.
Detecting wrong planner estimates
The PostgreSQL planner optimizes your queries, and mostly does it right. The question is: How to figure out when & where things do go wrong?
Logging - the hidden speedbrakes
When it comes to performance, people tend to forget some basic topics entirely. One of those topics is the impact of writing log files.
PostgreSQL 9.3 - Shared Buffers Performance (1)
A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week […]
Functions: The most widely ignored performance tweak
A PostgreSQL function performance can be marked as follows: VOLATILE, STABLE, IMMUTABLE or [NOT] LEAKPROOF. Undestand why.
