Materialized views with partitions in PostgreSQL

Question

Can we create materialized views with partitions in PostgreSQL (version 10.7) ?

Thanks

Laurenz Albe · Accepted Answer · 2020-08-24 06:26:58Z

3

No, you cannot, and it is not easy to think of a use case for that.

True, some carefully designed queries can be faster on a partitioned table, but most queries become slower.

You can work around the “deficiency” by creating a table and filling it with INSERT INTO ... SELECT ....

answered Aug 24, 2020 at 6:26

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

> a use case for that. Aggregations / reporting e.g. postgresql.org/message-id/…