On Sun, Feb 18, 2024 at 5:20 PM Alec Lazarescu <alecl@alecl.com> 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.