Allow single table VACUUM in transaction block

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Allow single table VACUUM in transaction block
Дата
Msg-id CANbhV-EGkXfWymABGyNo0ZiwOW8=QZ84CmTrYSNSUq1-XbBC7g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Allow single table VACUUM in transaction block
Re: Allow single table VACUUM in transaction block
Re: Allow single table VACUUM in transaction block
Список pgsql-hackers
It is a common user annoyance to have a script fail because someone
added a VACUUM, especially when using --single-transaction option.
Fix, so that this works without issue:

BEGIN;
....
VACUUM (ANALYZE) vactst;
....
COMMIT;

Allows both ANALYZE and vacuum of toast tables, but not VACUUM FULL.

When in a xact block, we do not set PROC_IN_VACUUM,
nor update datfrozenxid.

Tests, docs.

--
Simon Riggs                http://www.EnterpriseDB.com/

Вложения

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