Is there a way to avoid “refresh materialized view” generating WAL?

From: 李明 <liming185216(at)126(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Is there a way to avoid “refresh materialized view” generating WAL?
Date: 2026-09-08 01:50:24
Message-ID: 211A61C3-F742-4349-90B1-E7F616CAA646@126.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

We are using materialized view to speed up complex query,and found that every time we execute the command:refresh materialized view mv_name,it generated lots of WAL(the size is almost the same as the base table).

I checked the manual but did not find a “unlog” for materialized view.

So, Is there a way to avoid “refresh materialized view” generating WAL?or suppress it?

Thanks advance for any advice.

Ming

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message 李明 2026-09-08 05:05:16 Re: Is there a way to avoid “refresh materialized view” generating WAL?
Previous Message Pierre Forstmann 2026-09-02 18:31:05 Re: what is the difference between ROLE clause and IN ROLE clause for CREATE USER statement ?