Re: Partitioning options

2024-02-21 Thread Alec Lazarescu
l.org/message-id/CAE%2BE%3DSQacy6t_3XzCWnY1eiRcNWfz4pp02FER0N7mU_F%2Bo8G_Q%40mail.gmail.com Alec On Tue, Feb 20, 2024 at 11:59 AM Justin wrote: > > > On Sun, Feb 18, 2024 at 5:20 PM Alec Lazarescu wrote: >> >> "Would probably look at a nested partitioning" >> &g

Re: Partitioning options

2024-02-18 Thread Alec Lazarescu
"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 foreig