]> granicus.if.org Git - postgresql/commit
Add amcheck extension to contrib.
authorAndres Freund <andres@anarazel.de>
Thu, 9 Mar 2017 23:50:40 +0000 (15:50 -0800)
committerAndres Freund <andres@anarazel.de>
Fri, 10 Mar 2017 00:33:02 +0000 (16:33 -0800)
commit3717dc149ecf44b8be95350a68605ba7299474fd
tree0492818f880d969d6c18cdaf305dafc4d5bf7cbd
parentfe797b4a6a69ec0c9bf6ff992eac20c4084fda41
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@mail.gmail.com
13 files changed:
contrib/Makefile
contrib/amcheck/Makefile [new file with mode: 0644]
contrib/amcheck/amcheck--1.0.sql [new file with mode: 0644]
contrib/amcheck/amcheck.control [new file with mode: 0644]
contrib/amcheck/expected/check.out [new file with mode: 0644]
contrib/amcheck/expected/check_btree.out [new file with mode: 0644]
contrib/amcheck/sql/check.sql [new file with mode: 0644]
contrib/amcheck/sql/check_btree.sql [new file with mode: 0644]
contrib/amcheck/verify_nbtree.c [new file with mode: 0644]
doc/src/sgml/amcheck.sgml [new file with mode: 0644]
doc/src/sgml/contrib.sgml
doc/src/sgml/filelist.sgml
src/tools/pgindent/typedefs.list