]> granicus.if.org Git - postgresql/commit
Reduce lock levels for ALTER TABLE SET autovacuum storage options
authorSimon Riggs <simon@2ndQuadrant.com>
Fri, 14 Aug 2015 13:19:28 +0000 (14:19 +0100)
committerSimon Riggs <simon@2ndQuadrant.com>
Fri, 14 Aug 2015 13:19:28 +0000 (14:19 +0100)
commit47167b7907a802ed39b179c8780b76359468f076
tree0f52c9314b69cd80d7a4284f8d405db84122c4b9
parentf16d52269a196f7f303abe3b978d95ade265f05f
Reduce lock levels for ALTER TABLE SET autovacuum storage options

Reduce lock levels down to ShareUpdateExclusiveLock for all autovacuum-related
relation options when setting them using ALTER TABLE.

Add infrastructure to allow varying lock levels for relation options in later
patches. Setting multiple options together uses the highest lock level required
for any option. Works for both main and toast tables.

Fabrízio Mello, reviewed by Michael Paquier, mild edit and additional regression
tests from myself
doc/src/sgml/ref/alter_table.sgml
src/backend/access/common/reloptions.c
src/backend/commands/tablecmds.c
src/include/access/reloptions.h
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql