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 […]
How to cancel a hanging PostgreSQL query
by
Laurenz Albe |
05.2022 Sometimes a PostgreSQL query takes forever. Usually, it is easy to interrupt (cancel) such a statement, but sometimes it […]
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
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.
Tips and tricks to kick-start the Postgres year 2021
Start learning some new Postgres stuff again in 2021 and find some tips: Partial indexing, estimating average row size and more.
Query performance in PostgreSQL 13 RC1
In this blog posting you will learn more about query performance in the new PostgreSQL 13 RC1. Timings measured via ‘pg_stat_statements’
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, […]
Tracking view dependencies in PostgreSQL
by
Laurenz Albe |
09.2019 We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it: [crayon-67e2f50e630ca196553685/] […]
Implementing “AS OF”-queries in PostgreSQL
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.