Reproducible builds: a PostgreSQL query optimization example
This post shows how to optimize a slow query that came out of the Reproducible Builds project. The Reproducible Builds […]
Subqueries and performance in PostgreSQL
by
Laurenz Albe |
07.2023 SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]
Memory context: private memory management in PostgreSQL
by
Laurenz Albe |
06.2023 (updated 2025-01-27) PostgreSQL uses shared memory for data shared between processes. With the exception of the dynamic shared memory […]
Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]
Rewrite OR to UNION in PostgreSQL queries
by
Laurenz Albe |
11.2022 In my article that reviles OR, I showed how in certain cases, it is possible to rewrite OR in […]
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.
Join strategies and performance in PostgreSQL
by
Laurenz Albe |
06.2020 (Updated 2023-02-24) There are three join strategies in PostgreSQL that work quite differently. If PostgreSQL chooses the wrong strategy, […]
7 things that could be improved in PostgreSQL
UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.