Re: CREATE UNLOGGED MATERIALIZED VIEW

On 12/25/18 10:16 AM, Mitar wrote:
> Hi!
>
> That is for transient tables (NEW and OLD tables), no? Not for the
> main materialized view table.

Don't know. From my POV MATERIALIZED VIEWS are transient any way you
look at them. They capture a state at a point in time and then the data
they depend on moves on. Given that they can be refreshed at will not
sure logging/not logging really matters.

>
>
> 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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com