Re: avoid WAL for refresh of materialized view

Remund Alain writes: > Hi all > > > > We have PostgreSql 9.6 running and started to work with materialized > views. To refresh the materialized views, we set up a cron job that > refreshes the materialized views on a fix schedule. > > Since our materialized views cache quite some data, we notic

Re: avoid WAL for refresh of materialized view

Le mar. 24 mars 2020 à 17:00, Remund Alain a écrit : > Hi all > > > > We have PostgreSql 9.6 running and started to work with materialized > views. To refresh the materialized views, we set up a cron job that > refreshes the materialized views on a fix schedule. > > Since our materialized views c

avoid WAL for refresh of materialized view

Hi all We have PostgreSql 9.6 running and started to work with materialized views. To refresh the materialized views, we set up a cron job that refreshes the materialized views on a fix schedule. Since our materialized views cache quite some data, we noticed a considerable increase in WAL files