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

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app