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.

Great post! It's so interesting to learn about the PG lock behavior during schema changes. It's crazy how a seemingly harmless lock can still get blocked by another statement. 😮 Definitely something to keep in mind for future development work. Thanks for sharing this insightful information! 👍🏼