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