Postgres Pro
Downloads
Home   >   mailing lists

Thread: Declarative partitioning and materialized views

Declarative partitioning and materialized views

From
Wells Oliver
Date:
Hey all. Wondering if partitioning a table might help the speed of refreshing a materialized view that uses that table?

--

Re: Declarative partitioning and materialized views

From
Fabrízio de Royes Mello
Date:


Em sáb, 25 de jan de 2020 às 21:06, Wells Oliver <wells.oliver@gmail.com> escreveu:
Hey all. Wondering if partitioning a table might help the speed of refreshing a materialized view that uses that table?

It depends what filters are you using on the materialized view query.

Regards,
--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: Declarative partitioning and materialized views

From
Laurenz Albe
Date:
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