Refresh materialized view vs recreate - Mailing list pgsql-performance

From Антон Мазунин
Subject Refresh materialized view vs recreate
Date
Msg-id D5A51BDB-2EA7-4200-8F10-EB6AA5541DAC@gmail.com
Whole thread Raw
Responses Re: Refresh materialized view vs recreate  (Kevin Grittner <kgrittn@gmail.com>)
List 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?

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Tuning Checkpoints
Next
From: Kevin Grittner
Date:
Subject: Re: Refresh materialized view vs recreate