Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Hello All Here is the presentation, it was done under "Percona University Athens". It went ok, I think, although people didn't seem to understand much, as the audience was MySQL/PostgreSQL/Mongo/Oracle mix. However some young people seemed to be interested as they asked questions afterwards.

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:58, ο/η Achilleas Mantzios έγραψε: Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: 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 implement

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 20:06, ο/η Laurenz Albe έγραψε: On Mon, 2023-10-23 at 19:49 +0300, Achilleas Mantzios wrote: Tom Lane wrote:  But there are valid use-cases where you actually do want more columns in the child tables than the parent. also data departmentalization, consolidation, multi-tenancy ar

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

On Mon, 2023-10-23 at 19:49 +0300, Achilleas Mantzios wrote: > Tom Lane wrote: > > But there are valid use-cases where you > > actually do want more columns in the child tables than the parent. > > also data departmentalization, consolidation, multi-tenancy are fine use > cases (same # and types

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

On 10/23/23 09:51, Achilleas Mantzios wrote: Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios - cloud wrote: 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 Novemb

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: 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

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:07, ο/η Christophe Pettus έγραψε: On Oct 23, 2023, at 04:45, Achilleas Mantzios - cloud wrote: 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 adv

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

On 2023-Oct-23, Achilleas Mantzios wrote: > 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. For partitioning, many of the limit

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios - cloud wrote: 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/tea

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:35, ο/η Tom Lane έγραψε: Achilleas Mantzios - cloud 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

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Achilleas Mantzios - cloud 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.

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

> On Oct 23, 2023, at 04:45, Achilleas Mantzios - cloud > wrote: > 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 co

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

On 2023-Oct-23, Achilleas Mantzios - cloud wrote: > 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

PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Hello All in the wiki above and specifically in this commit : https://wiki.postgresql.org/index.php?title=Don%27t_Do_This&type=revision&diff=33210&oldid=33082 someone added this section about inheritance : " Don't use table inheritance Don't use table inheritance