PostgreSQL: Detecting slow queries quickly
UPDATED Mar 2023: How to use pg_stat_statements to detect slow queries - including examples and code - improve PostgreSQL performance
Terminating database connections in PostgreSQL
This blog posting explains you, how to terminate queries and database connections in PostgreSQL. Find out more.
How the PostgreSQL query optimizer works
Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.
PostgreSQL: CREATE STATISTICS - advanced query optimization
The PostgreSQL query planner doesn't know which data usually correlates. How to use CREATE STATISTICS to find correlations.
PostgreSQL: ANALYZE and optimizer statistics
To find the best execution plan PostgreSQL is relying on statistics to give the optimizer an indication of what to expect.
PostgreSQL: What is a checkpoint?
How to use checkpoints and checkpoint tuning, and how PostgreSQL writes data, database internals explained.
This article covers scaling advices for PostgreSQL and explains why it may be a good idea to keep it simple on the database side.
BLOB cleanup in PostgreSQL
PostgreSQL offers a nice BLOB interface which is widely used. Learn more about how PostgreSQL handles BLOBs - and especially BLOB cleanup.
Insert-only data modelling to smooth peaks on slow disks
Using insert-only data modelling to smooth peaks on slow disks. Nice design trick that alleviates performance problems when used correctly
PostgreSQL clustering: vip-manager
vip-manager is a simple to use tool to handle service IPs in a PostgreSQL Patroni cluster | PostgreSQL High Availability Cluster
