Refresh materialized view vs recreate

From: Антон Мазунин <mazuninanton(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Refresh materialized view vs recreate
Date: 2016-11-01 06:26:42
Message-ID: D5A51BDB-2EA7-4200-8F10-EB6AA5541DAC@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 the difference between refresh and create new?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2016-11-01 15:25:45 Re: Refresh materialized view vs recreate
Previous Message Tomas Vondra 2016-10-31 21:59:50 Re: Tuning Checkpoints