Postgres FM cover image

Partitioning

Postgres FM

CHAPTER

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.

00:00
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