Request a Demo
Home   >   mailing lists

Is there a way to avoid “refresh materialized view” generating WAL? - Mailing list pgsql-admin

From 李明
Subject Is there a way to avoid “refresh materialized view” generating WAL?
Date
Msg-id 211A61C3-F742-4349-90B1-E7F616CAA646@126.com
Whole thread
Responses Re: Is there a way to avoid “refresh materialized view” generating WAL?
List pgsql-admin
Tree view 
Hi all,

We are using materialized view to speed up complex query,and found that every time we execute the command:refresh
materializedview 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

pgsql-admin by date:

Previous
From: bertrand HARTWIG
Date:
Subject: Re: How to definitively determine whether a statement is a SELECT statement?
Next
From: Laurenz Albe
Date:
Subject: Re: Is there a way to avoid “refresh materialized view” generating WAL?