Locks

Nikolay and Michael discuss heavyweight locks in Postgres — how to think about them, why you can't avoid them, and some tips for minimising issues.

Here are some links to things they mentioned:
• Locking (docs) postgresql.org/docs/current/explicit-locking.h…
• Postgres rocks, except when it blocks (blog post by Marco Slot) citusdata.com/blog/2018/02/15/when-postgresql-…
• Lock Conflicts (tool by Hussein Nasser) pglocks.org
• log_lock_waits (docs) postgresql.org/docs/current/runtime-config-log…
• How to analyze heavyweight lock trees (guide by Nikolay) gitlab.com/postgres-ai/postgresql-consulting/p…
• Lock management (docs) postgresql.org/docs/current/runtime-config-loc…
• Our episode on zero-downtime migrations postgres.fm/episodes/zero-downtime-migrations

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork