The Backend Engineering Show with Hussein Nasser cover image

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.
App store bannerPlay store banner