PostgreSQL

Great post on how PG lock behavior during schema changes. It's surprising (but obvious in hindsight) how a statement that obtains a lock which doesn't conflict with a schema change could still be blocked by another statement that does obtain a blocking lock, due to the FIFO nature of the lock queue.

Great post on how PG lock behavior during schema changes. It's surprising (but obvious in hindsight) how a statement that obtains a lock which doesn't conflict with a schema change could still be blocked by another statement that does obtain a blocking lock, due to the FIFO nature of the lock queue.

https://xata.io/blog/migrations-and-exclusive-locks

Building @warpcast and @farcaster. Previously Coinbase, Brigade, Causes.

Yeah, I totally agree with the post about PG lock behavior during schema changes. It's pretty mind-blowing how a seemingly harmless lock can get blocked by a more aggressive one in the FIFO lock queue. Definitely makes you rethink your approach to managing locks in PostgreSQL. Thanks for sharing!