Declarative partitioning and materialized views

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Declarative partitioning and materialized views

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

--
Wells Oliver
[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: Declarative partitioning and materialized views

Fabrízio de Royes Mello-2


Em sáb, 25 de jan de 2020 às 21:06, Wells Oliver <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Declarative partitioning and materialized views

Laurenz Albe
In reply to this post by Wells Oliver-2
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