On Sun, Feb 18, 2024 at 5:20 PM Alec Lazarescu <alecl@xxxxxxxxx> wrote:
"Would probably look at a nested partitioning"
I'm not the original poster, but I have a schema with nested
(composite) partitions and I do run into some significant
inefficiencies compared to flat partitions in various schema metadata
operations (queries to get the list of tables, creating foreign keys,
etc.) in tables with 1,000+ total partitions.
One example: https://www.postgresql.org/message-id/CAE%2BE%3DSQacy6t_3XzCWnY1eiRcNWfz4pp02FER0N7mU_F%2Bo8G_Q%40mail.gmail.com
Alec
Hi Alec,
would need to see the DDL of the partitions and the queries accessing these partitions to have an opinion
Thank you
Justin
would need to see the DDL of the partitions and the queries accessing these partitions to have an opinion
Thank you
Justin
