Pawel Urbanek personal blog

PostgreSQL query performance bottlenecks

by Paweł Urbanek pawelurbanek.com published 2022-01-188 min read

PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I'll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.

Points

249

HN comments

41

Submissions

1

Cited by

0 commenters

Databases & DataSystems & Performance2022

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

Pphiresky20211,812 points314 commentscited by 26 details

I'm all-in on server-side SQLite

Fly.io Blog20221,353 points565 commentscited by 16 details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

Datomic is Free

DDatomic Blog20231,099 points368 commentscited by 5 details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details