pgsql: Add integrity-checking functions to pg_visibility.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add integrity-checking functions to pg_visibility.
Date: 2016-06-15 18:44:30
Message-ID: E1bDFni-0002aH-Bm@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add integrity-checking functions to pg_visibility.

The new pg_check_visible() and pg_check_frozen() functions can be used to
verify that the visibility map bits for a relation's data pages match the
actual state of the tuples on those pages.

Amit Kapila and Robert Haas, reviewed (in earlier versions) by Andres
Freund. Additional testing help by Thomas Munro.

Branch
------
master

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

Modified Files
--------------
contrib/pg_visibility/Makefile | 2 +-
contrib/pg_visibility/pg_visibility--1.0--1.1.sql | 17 ++
contrib/pg_visibility/pg_visibility--1.0.sql | 52 ----
contrib/pg_visibility/pg_visibility--1.1.sql | 67 +++++
contrib/pg_visibility/pg_visibility.c | 313 ++++++++++++++++++++++
contrib/pg_visibility/pg_visibility.control | 2 +-
doc/src/sgml/pgvisibility.sgml | 28 +-
src/tools/pgindent/typedefs.list | 1 +
8 files changed, 427 insertions(+), 55 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2016-06-15 18:45:37 Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Previous Message Kevin Grittner 2016-06-15 18:42:19 Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <