| From: | Mitar <mmitar(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: CREATE UNLOGGED MATERIALIZED VIEW |
| Date: | 2018-12-25 18:16:07 |
| Message-ID: | CAKLmikPd9kDSH0gXjnYL2-CjBo=q=jo88x3fHTsScPLtrCdW4A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-12-25 18:25:23 | Re: CREATE UNLOGGED MATERIALIZED VIEW |
| Previous Message | Adrian Klaver | 2018-12-25 18:14:06 | Re: CREATE UNLOGGED MATERIALIZED VIEW |