Re: [PERFORM] Refresh materialized view vs recreate

2016-11-01 Thread Kevin Grittner
On Tue, Nov 1, 2016 at 1:26 AM, Антон Мазунин wrote: > We have a situation when after creation of new materialized view > cpu utilization falls down (from about 50% to about 30%), at the > same time we have a cron job, which does refresh of old > materialized view, but it does no effect at perfor

[PERFORM] Refresh materialized view vs recreate

2016-10-31 Thread Антон Мазунин
Hello! We have a situation when after creation of new materialized view cpu utilization falls down (from about 50% to about 30%), at the same time we have a cron job, which does refresh of old materialized view, but it does no effect at performance. Can anyone explain why is it so? And what is