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
• GitHub - jorzel/concurrency-control: In this repo I would like to show 4 strategies of concurrency control for writing data using Python SQLAlchemy ORM and PostgresSQL (however this examples could be easily transformed to plain SQL).github.com
• The startup's Postgres survival guidehatchet.run
• Making 768 servers look like 1 — PlanetScaleplanetscale.com
• Benchmarking How Workflow Execution Scales on Postgres | DBOSdbos.dev
• An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
• Scaling PostgreSQL to power 800 million ChatGPT users | OpenAIopenai.com
• Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com
• Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
• The most useful Postgres extension: pg_stat_statements - Citus Datacitusdata.com
• The only scalable delete in Postgres is DROP TABLE — PlanetScaleplanetscale.com
• PostgreSQL: Documentation: 18: 13.2. Transaction Isolationpostgresql.org