Обсуждение: Declarative partitioning and materialized views

Поиск
Список
Период
Сортировка

Declarative partitioning and materialized views

От
Wells Oliver
Дата:
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

От
Fabrízio de Royes Mello
Дата:


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

От
Laurenz Albe
Дата:
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