Re: Declarative partitioning and materialized views - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Declarative partitioning and materialized views
Date
Msg-id 8025740856ba14e672f21f8b89eaf705ca87428c.camel@cybertec.at
Whole thread Raw
In response to Declarative partitioning and materialized views  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
On Sat, 2020-01-25 at 16:05 -0800, Wells Oliver wrote:
> Hey all. Wondering if partitioning a table might help the speed of refreshing a materialized view that uses that
table?

Probably not, but that depends on the query used to define the view.

If that query becomes faster by partitioning the table, then partitioning will help.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-admin by date:

Previous
From: manish yadav
Date:
Subject: Re: EFM Startup Failed
Next
From:
Date:
Subject: RE: pg_rewind