]> granicus.if.org Git - postgresql/commit
Allow VACUUM to be run with index cleanup disabled.
authorRobert Haas <rhaas@postgresql.org>
Thu, 4 Apr 2019 18:58:53 +0000 (14:58 -0400)
committerRobert Haas <rhaas@postgresql.org>
Thu, 4 Apr 2019 19:04:43 +0000 (15:04 -0400)
commita96c41feec6b6616eb9d5baee9a9e08c20533c38
tree8224a04fbe5c2165fd2ed18655aa63259c234ae4
parent74eb2176bf3ac7a2fae1282b4f4f1d000f3e6d78
Allow VACUUM to be run with index cleanup disabled.

This commit adds a new reloption, vacuum_index_cleanup, which
controls whether index cleanup is performed for a particular
relation by default.  It also adds a new option to the VACUUM
command, INDEX_CLEANUP, which can be used to override the
reloption.  If neither the reloption nor the VACUUM option is
used, the default is true, as before.

Masahiko Sawada, reviewed and tested by Nathan Bossart, Alvaro
Herrera, Kyotaro Horiguchi, Darafei Praliaskouski, and me.
The wording of the documentation is mostly due to me.

Discussion: http://postgr.es/m/CAD21AoAt5R3DNUZSjOoXDUY=naYPUOuffVsRzuTYMz29yLzQCA@mail.gmail.com
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/ref/vacuum.sgml
src/backend/access/common/reloptions.c
src/backend/access/heap/vacuumlazy.c
src/backend/commands/vacuum.c
src/backend/postmaster/autovacuum.c
src/bin/psql/tab-complete.c
src/include/commands/vacuum.h
src/include/utils/rel.h
src/test/regress/expected/vacuum.out
src/test/regress/sql/vacuum.sql