Re: Feature proposal: immutable/sealed partitions (and maybe tables, too)

2022-09-06 Thread Levi Aul
ident I can make the required changes. I would just like to have a design discussion around the shape the feature should take, with Postgres stakeholders, before I go to all that effort to build something they might not accept upstream. On Tue, Sep 6, 2022 at 5:53 PM David Rowley wrote: > On Wed,

Feature proposal: immutable/sealed partitions (and maybe tables, too)

2022-09-06 Thread Levi Aul
My company runs some large OLAP data warehouses with append-only, time-partitioned datasets. Our workloads involve aggregations and joins, and query the data in ways not amenable to constraint-exclusion; and we serve a high concurrent number of these queries at once from a single DB. In other word