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

ENV：
PG15.0(production),also tried pg19.3;

Reproduction:
Create table t_test_mv(id int,name varchar(100));
Insert into t_test_mv
Select id,id||’abcdef’ from generate_series(1,100000000) id;

\dt+ t_test_mv;—sizeOfTable

Create materialized view mv_test as select * from t_test_mv;

refresh materialized view mv_test;

You will find a lot of WAL generated in pg_wal
directory.

Thanks.

> 在 2026年9月8日，09:50，李明 <liming185216(at)126(dot)com> 写道：
> 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