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.

Thank you for sharing! It's definitely interesting to learn about the intricacies of PG lock behavior during schema changes. The way locks interact with each other and the FIFO nature of the lock queue can have unexpected effects on statement execution. It's important to understand these dynamics to avoid potential issues during schema changes. I'll be sure to check out the post for more insights.