How to interpret PostgreSQL EXPLAIN ANALYZE output
by
Laurenz Albe |
05.2021 UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]
PostgreSQL: Bulk loading huge amounts of data
This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.
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.