From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This
Date: Mon, 23 Oct 2023 19:49:04 +0300
Message-ID: <23469ec0-674e-470a-b6eb-dfcb376c5049@cloud.gatewaynet.com> (raw)
In-Reply-To: <374847.1698071743@sss.pgh.pa.us>
References: <2f106761-daa8-6b26-013e-884da25322c2@cloud.gatewaynet.com>
<374847.1698071743@sss.pgh.pa.us>
Στις 23/10/23 17:35, ο/η Tom Lane έγραψε:
> Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com> writes:
>> someone added this section about inheritance :
>> Don't use table inheritance
> That's one person's opinion. (Well, they're not alone in it, but
> it's just an opinion not a considered community position.)
>
>> I believe this text is false on too many accounts. So, what's the
>> consensus about Inheritance in PostgreSQL, I am going to give a talk on
>> it in November and I wouldn't like to advertise/promote/teach something
>> that the community has decided to abandon or drop.
> There's zero chance we'd remove table inheritance. In the first
> place, we have too much concern for backwards compatibility, and
> in the second place, table partitioning is built on top of it.
> Probably no one is going to work hard on adding more features
> directly concerned with non-partitioned inheritance, but it's
> not going anywhere either.
>
> You should certainly make the point that if your problem looks like
> partitioning, you should use partitioning rather than some hand-rolled
> use of plain inheritance. But there are valid use-cases where you
> actually do want more columns in the child tables than the parent.
Thanks Tom,
also data departmentalization, consolidation, multi-tenancy are fine use
cases (same # and types of columns), you can't have writable VIEWs with
UNION, for me inheritance is a fantastic feature that I use with success
for some very important projects.
Yes I make clear in the talk, that table partitioning is better done
using declarative partitioning introduced in v10, but mysql and mongodb
ppl (majority in the event) are not interested in pgsql partitioning as
a top feature, I guess they have their own solutions for years.
Here is a cool use case for heavy DDL (ETL) on big tables :
https://www.percona.com/blog/performing-etl-using-inheritance-in-postgresql/
nothing that could not be done via VIEWs and rules, but still more elegant.
I find PostgreSQL inheritance a great feature. The caveats are the same
since a long time, nothing changed in that regard, but as you say, the
implementation/limitations exist in native table partitioning as well.
In fact I wonder how some enterprise ppl live without it. If you are
interested I'd happily share the doc with the list.
>
> regards, tom lane
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: a.mantzios@cloud.gatewaynet.com, tgl@sss.pgh.pa.us
Subject: Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This
In-Reply-To: <23469ec0-674e-470a-b6eb-dfcb376c5049@cloud.gatewaynet.com>
References: <2f106761-daa8-6b26-013e-884da25322c2@cloud.gatewaynet.com> <374847.1698071743@sss.pgh.pa.us> <23469ec0-674e-470a-b6eb-dfcb376c5049@cloud.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox