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.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
