pgsql: WAL-log the extension of a new empty MV heap which is being popu

From: Kevin Grittner <kgrittn(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: WAL-log the extension of a new empty MV heap which is being popu
Date: 2013-03-06 23:16:48
Message-ID: E1UDNZo-0001vH-IG@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

WAL-log the extension of a new empty MV heap which is being populated.

This page with no tuples is used to distinguish an MV containing a
zero-row resultset of its backing query from an MV which has not
been populated by its backing query. Unless WAL-logged, recovery
and hot standby don't work correctly with what should be an empty
but scannable materialized view.

Fixes bugs reported by Fujii Masao in testing MVs on hot standby.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c5bf7a2052c8e7ebbd1ca3986525c3629d7345d1

Modified Files
--------------
src/backend/commands/matview.c | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2013-03-06 23:21:20 pgsql: Fix missing #include in commands/matview.h.
Previous Message Tatsuo Ishii 2013-03-06 22:45:22 Re: Materialized views WIP patch