@sds

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

1 reply

3 recasts

13 reactions