Re: Declarative partitioning and materialized views

From: Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Declarative partitioning and materialized views
Date: 2020-01-26 14:33:37
Message-ID: CAPfkCSDTyvQ6sKDu5O4h=gt-KzYjRv7nmCQS3ppKdSYoXqKTtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Em sáb, 25 de jan de 2020 às 21:06, Wells Oliver <wells(dot)oliver(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Wainaina 2020-01-27 05:55:51 HOW TO FIX LOCK ISSUE DURING DML
Previous Message Magnus Hagander 2020-01-26 12:08:57 Re: EFM Startup Failed