Re: CREATE UNLOGGED MATERIALIZED VIEW - Mailing list pgsql-general

From Mitar
Subject Re: CREATE UNLOGGED MATERIALIZED VIEW
Date
Msg-id CAKLmikPd9kDSH0gXjnYL2-CjBo=q=jo88x3fHTsScPLtrCdW4A@mail.gmail.com
Whole thread Raw
In response to Re: CREATE UNLOGGED MATERIALIZED VIEW  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: CREATE UNLOGGED MATERIALIZED VIEW  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi!

That is for transient tables (NEW and OLD tables), no? Not for the
main materialized view table.


Mitar

On Tue, Dec 25, 2018 at 10:14 AM Adrian Klaver
<adrian.klaver@aklaver.com> wrote:
>
> On 12/25/18 1:13 AM, Mitar wrote:
> > Hi!
> >
> > I am looking at parser grammar rules and it looks like the following
> > is a valid query:
> >
> > CREATE UNLOGGED MATERIALIZED VIEW
> >
> > Any particular reason this is not documented?
>
> My guess because of this:
>
> https://doxygen.postgresql.org/matview_8c.html
>
> Line 458-461
>
> "/*
>        * We can skip WAL-logging the insertions, unless PITR or streaming
>        * replication is in use. We can skip the FSM in any case.
>   */
> "
>
> >
> >
> > Mitar
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: CREATE UNLOGGED MATERIALIZED VIEW
Next
From: Adrian Klaver
Date:
Subject: Re: CREATE UNLOGGED MATERIALIZED VIEW