pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option
Дата
Msg-id E1ZQEu4-00060o-AO@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-committers
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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/47167b7907a802ed39b179c8780b76359468f076

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml         |    4 +
src/backend/access/common/reloptions.c    |  144 +++++++++++++++++++++++------
src/backend/commands/tablecmds.c          |    6 +-
src/include/access/reloptions.h           |    3 +
src/test/regress/expected/alter_table.out |   67 ++++++++++++--
src/test/regress/sql/alter_table.sql      |   38 ++++++++
6 files changed, 219 insertions(+), 43 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pgsql: Allow pg_create_physical_replication_slot() to reserve WAL.
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Update key words table for 9.5