pgsql: Prevent (auto)vacuum from truncating first page of populated mat

From: Kevin Grittner <kgrittn(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prevent (auto)vacuum from truncating first page of populated mat
Date: 2013-05-02 22:38:27
Message-ID: E1UY28x-0007t7-Mc@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prevent (auto)vacuum from truncating first page of populated matview.

Per report from Fujii Masao, with regression test using his example.

Branch
------
master

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

Modified Files
--------------
src/backend/commands/vacuumlazy.c | 6 ++++++
src/test/regress/expected/matview.out | 20 ++++++++++++++++++++
src/test/regress/sql/matview.sql | 12 ++++++++++++
3 files changed, 38 insertions(+), 0 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2013-05-02 23:14:51 pgsql: 9.3 release notes: suggested improvements from Jeff Janes and J
Previous Message Greg Stark 2013-05-02 21:19:42 Re: pgsql: pg_test_fsync: update output to show usecs/op clearer