Checkpoint distance and amount of WAL
Tuning the database server affects the amount of WAL written to disk. Fewer checkpoints are a good idea for bigger databases.
Detecting unstable execution times in PostgreSQL
How to tune a query which is sometimes slow and sometimes fast. The question is usually: How come it has an unstable execution time?
pg_basebackup: Creating self-sufficient backups
UPDATED Aug 2023 How to use pg_basebackup: allows users to create a binary copy of their data, which is the basis for Point-In-Time-Recovery.
Parallel queries and SERIALIZABLE transactions
In version 9.6 PostgreSQL introduced parallel queries. The ability to use more than just one CPU core per query is […]
Will more disks get you better PostgreSQL performance?
Find out whether to buy more hardware to fix performance problems - which are in many cases not caused by bad disk performance.
Exploding runtime: How nested loops can destroy speed
What will happen if the PostgreSQL optimizer underestimates the number of rows involved in nested loops? Includes ways to fix the problem.
paginators - The story about voluntary pain in PostgreSQL
If you want to display millions of entries on your website, you definitely turn to paginators. Here's how you do it right using PostgreSQL.
Inheritance - One more reason to love PostgreSQL
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
PostgreSQL instance-level encryption
Business critical applications require full encryption to match legal requirements. We published a patch to provide full database encryption.