
They Enabled Postgres Partitioning and their Backend fell apart
The Backend Engineering Show with Hussein Nasser
00:00
How to Detach Daily Partitions in Postgres 14
In postgres 14, there's a fix for this called detach concurrently. It acquires as a software lock, which allows you to continue to edit it essentially. If you click on detach partition, it acquires an access exclusive lock and look what blocks it blocks command conflicting with alter table detach partition pretty much everything. The order table became completely unaccessible. So oh my god, that's even just skyrocketed the way it's even more and more.
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.