Postgres Advisory Locks for Coordinating Work Across Monolith Replicas
How postgres advisory locks work, how to use them for singleton jobs and leader election across replicas, and the session and pooling pitfalls to design around.
15 min read
Tag
How postgres advisory locks work, how to use them for singleton jobs and leader election across replicas, and the session and pooling pitfalls to design around.
15 min read
Stop scheduled jobs from running once per replica using advisory locks, ShedLock-style lock tables, or leader election, and make them idempotent.
14 min read
Learn how pgbouncer transaction mode releases connections, which session features break, safe replacements, prepared statements, sizing, and a migration audit.
13 min read