AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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.