Support for partitioned tables

[paurora17]

What feature are you requesting?

Today, CREATE TABLE ... USING columnstore is incompatible with partitioned tables.

Why are you requesting this feature?

Want to keep a history of up to 90 days in the DB, but to start archiving data after that period.

What is your proposed implementation for this feature?

No response

[pantonis]

It would be good to have this. One of the 2 things that keep us from using pg_mooncake

[zhousun]

373bfc5
should cover most use cases of partitioned tables in postgres.

For time series use cases, each file will likely only contain data from similar time range.
So at query time, based on the filter, most data files will be skipped.