From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Remund Alain <alain(dot)remund(at)bertschi(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: avoid WAL for refresh of materialized view |
Date: | 2020-03-24 16:03:42 |
Message-ID: | CAECtzeXru8OZ2hyeBqbAA1AjgK7R1qp_82KeSNeEooZ6X66_yQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Le mar. 24 mars 2020 à 17:00, Remund Alain <alain(dot)remund(at)bertschi(dot)com> a
écrit :
> Hi all
>
>
>
> We have PostgreSql 9.6 running and started to work with materialized
> views. To refresh the materialized views, we set up a cron job that
> refreshes the materialized views on a fix schedule.
>
> Since our materialized views cache quite some data, we noticed a
> considerable increase in WAL files. It seems, that every refresh of a
> materialized view is logged in the WAL.
>
>
>
> We tried to figure out how we can alter the materialized view to set it to
> "UNLOGGED" but this does not seem possible.
>
> --> "alter materialized view xyz set UNLOGGED;" leads to "ERROR: "xyz" is
> not a table, SQL state: 42809"
>
>
>
> Is there another way to avoid logging a refresh of a materialized view in
> the WAL?
>
>
>
As you say, there is no unlogged materialized view. So, no, it will always
log to the WAL during refresh.
>
--
Guillaume.
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2020-03-24 16:49:24 | Re: avoid WAL for refresh of materialized view |
Previous Message | Remund Alain | 2020-03-24 15:59:46 | avoid WAL for refresh of materialized view |