PostgreSQL rocks, except when it blocks: Understanding locks

While the open source Postgres database is amazing at running multiple operations at the same time, there are cases in which Postgres needs to block an operation using a lock. This post by Marco Slot & the distributed database team at Citus Data is all about understanding locking behaviors in Postgres.

PostgreSQL rocks, except when it blocks: Understanding locks - Citus Data The schedule is out 🗓️ for POSETTE: An Event for Postgres 2026! Skip navigation SHARE THIS POST Share on X Share on LinkedIn Copy link Get our monthly newsletter On the Citus open source team, we engineers take an active role in helping our users scale out their Postgres database, be it for migrating an existing application or building a new application from scratch . This means we help you with distributing your relational data model—and also with getting the most out of Postgres. One problem I often see

saved by

• William S

related reading

• Explaining The Postgres Memeavestura.dev
• An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
• Scaling PostgreSQL to power 800 million ChatGPT users | OpenAIopenai.com
• Benchmarking How Workflow Execution Scales on Postgres | DBOSdbos.dev
• Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com
• Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
• The only scalable delete in Postgres is DROP TABLE — PlanetScaleplanetscale.com
• The most useful Postgres extension: pg_stat_statements - Citus Datacitusdata.com
• Making Postgres 42,000x slower because I am unemployedbyteofdev.com
• PostgreSQL: Documentation: 18: 13.2. Transaction Isolationpostgresql.org
• PostgreSQL: Documentation: 7.1: Multi-Version Concurrency Controlpostgresql.org
• PgBouncer is useful, important, and fraught with peril - JP Camarajpcamara.com