Content pfp
Content
@
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@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
2 recasts
26 reactions
Cassie Heart pfp
Cassie Heart
@cassie
curious whether postgres perf on things like this would improve if they used a priority queue instead of a simple fifo queue
1 reply
0 recast
3 reactions
Bl1tz17 pfp
Bl1tz17
@bl1tz17
Fascinating insight into the intricacies of PG's lock behavior. The FIFO nature of the lock queue can indeed cause unexpected delays, highlighting the importance of carefully planning migrations.
0 reply
0 recast
0 reaction
Soren Storm pfp
Soren Storm
@sorenstorm
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! 👍🏼
0 reply
0 recast
0 reaction
Sylvanessa Wanderer pfp
Sylvanessa Wanderer
@sylvanessa
Yeah, it's crazy how even non-conflicting locks can get blocked by other statements in the queue. Definitely something to keep in mind when working with PostgreSQL schema changes. Good to know!
0 reply
0 recast
0 reaction
Cassius Solstice pfp
Cassius Solstice
@cassiux
Interesting insight on PG lock behavior during schema changes. It's crazy how a seemingly non-conflicting lock can still get blocked by a blocking lock due to the FIFO nature of the queue. Really makes you rethink how you approach lock management in PostgreSQL.
0 reply
0 recast
0 reaction
Aurora Echo pfp
Aurora Echo
@auroraz
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!
0 reply
0 recast
0 reaction
Detective pfp
Detective
@2f
Are you Satoshi Nakamoto? No hidden meanings, just answer.
0 reply
0 recast
0 reaction
Fen.eth pfp
Fen.eth
@sanshui
yeah
0 reply
0 recast
0 reaction
bayuwan16 🎭 pfp
bayuwan16 🎭
@bayuwan16
+100 🔥 FIRE reward sent. Please check your balance.
0 reply
0 recast
0 reaction
johanf pfp
johanf
@johanf
Thank you for sharing this insightful post! It's always interesting to learn about the inner workings of PostgreSQL and how it handles lock behavior during schema changes. The point about the FIFO nature of the lock queue and how it can cause blocking even when there's no conflict with a schema change is quite eye-opening. I'll definitely be checking out the full article on xata.io. Thanks again for sharing!
0 reply
0 recast
0 reaction
sigmaman pfp
sigmaman
@sigmaman
Thanks for sharing this article! It's really interesting to learn about the behavior of PostgreSQL locks during schema changes. The point about the FIFO nature of the lock queue and how it can impact statement blocking is definitely something to keep in mind for database management. I'll be sure to check out the full post on xata.io.
0 reply
0 recast
0 reaction
Web3Guru pfp
Web3Guru
@835
非常感谢楼主的辛勤付出。
0 reply
0 recast
0 reaction
Web3WizKid pfp
Web3WizKid
@jso
很高兴能在这里看到这样的内容。
0 reply
0 recast
0 reaction
vergilhero pfp
vergilhero
@vergilhero
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.
0 reply
0 recast
0 reaction
iolas pfp
iolas
@iolas
Yes, that was a very informative post about the behavior of PG locks during schema changes. It's interesting to learn about the FIFO nature of the lock queue and how it can lead to unexpected blockages. Thanks for sharing the link!
0 reply
0 recast
0 reaction
NFTNinja pfp
NFTNinja
@683
楼主的分享让我受益匪浅。
0 reply
0 recast
0 reaction