Postgres FM cover image

Partitioning

Postgres FM

00:00

The Benefits of Inheritance Based Partitioning

Inheritance based partitioning existed for long and inheritance is a good concept that's from the era when like object relational database concept was popular late 90s early 2000 but declarative partitioning is much easier to use. Now of course I would not use inheritance based partitioning at all expect very rare cases, so let's talk about why do we need it at all or do you think?Yeah so I mean I bump into different reasons that people want to do this but the main one I see is maintenance so easier and more parallelizable maintenance ability to... So that includes things like indexing, re-indexing, vacuum, analyze probably a bunch of things I'm forgetting there.

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