From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Add amcheck extension to contrib. |
Date: | 2017-03-10 00:40:56 |
Message-ID: | E1cm8c4-0006kP-93@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Add amcheck extension to contrib.
This is the beginning of a collection of SQL-callable functions to
verify the integrity of data files. For now it only contains code to
verify B-Tree indexes.
This adds two SQL-callable functions, validating B-Tree consistency to
a varying degree. Check the, extensive, docs for details.
The goal is to later extend the coverage of the module to further
access methods, possibly including the heap. Once checks for
additional access methods exist, we'll likely add some "dispatch"
functions that cover multiple access methods.
Author: Peter Geoghegan, editorialized by Andres Freund
Reviewed-By: Andres Freund, Tomas Vondra, Thomas Munro,
Anastasia Lubennikova, Robert Haas, Amit Langote
Discussion: CAM3SWZQzLMhMwmBqjzK+pRKXrNUZ4w90wYMUWfkeV8mZ3Debvw(at)mail(dot)gmail(dot)com
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/3717dc149ecf44b8be95350a68605ba7299474fd
Modified Files
--------------
contrib/Makefile | 1 +
contrib/amcheck/Makefile | 21 +
contrib/amcheck/amcheck--1.0.sql | 24 +
contrib/amcheck/amcheck.control | 5 +
contrib/amcheck/expected/check.out | 1 +
contrib/amcheck/expected/check_btree.out | 90 +++
contrib/amcheck/sql/check.sql | 1 +
contrib/amcheck/sql/check_btree.sql | 59 ++
contrib/amcheck/verify_nbtree.c | 1249 ++++++++++++++++++++++++++++++
doc/src/sgml/amcheck.sgml | 273 +++++++
doc/src/sgml/contrib.sgml | 1 +
doc/src/sgml/filelist.sgml | 1 +
src/tools/pgindent/typedefs.list | 2 +
13 files changed, 1728 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-03-10 00:46:32 | Re: [COMMITTERS] pgsql: Fix hard-coded relkind constants in pg_dump.c. |
Previous Message | Tom Lane | 2017-03-10 00:19:37 | pgsql: Make CppAsString2() more visible in c.h. |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-03-10 00:41:42 | Re: amcheck (B-Tree integrity checking tool) |
Previous Message | Stephen Frost | 2017-03-10 00:34:45 | Re: contrib modules and relkind check |