Postgres Pro
Downloads
Home   >   mailing lists

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

From Fabrízio de Royes Mello
Subject Re: Declarative partitioning and materialized views
Date
Msg-id CAPfkCSDTyvQ6sKDu5O4h=gt-KzYjRv7nmCQS3ppKdSYoXqKTtg@mail.gmail.com
Whole thread Raw
In response to Declarative partitioning and materialized views  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: EFM Startup Failed
Next
From: Peter Wainaina
Date:
Subject: HOW TO FIX LOCK ISSUE DURING DML