Re: Improve behavior of concurrent ANALYZE/VACUUM

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Improve behavior of concurrent ANALYZE/VACUUM
Дата
Msg-id 20180822053637.GC4333@paquier.xyz
обсуждение исходный текст
Ответ на Re: Improve behavior of concurrent ANALYZE/VACUUM  ("Bossart, Nathan" <bossartn@amazon.com>)
Ответы Re: Improve behavior of concurrent ANALYZE/VACUUM
Список pgsql-hackers
On Wed, Aug 22, 2018 at 02:17:44AM +0000, Bossart, Nathan wrote:
> I think this is doable by locking the table in SHARE mode.  That won't
> conflict with the AccessShareLock that expand_vacuum_rel() obtains,
> but it will conflict with the ShareUpdateExclusiveLock or
> AccessExclusiveLock that vacuum_rel() takes.

Good point.  Still is that really worth adding?  This implies a test
which has at least two roles, one switching the ownership to the other
and do so back-and-forth.  At least that should be on a different
isolation spec file to not complicate the first one.
--
Michael

Вложения

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

Предыдущее
От: "Yamaji, Ryo"
Дата:
Сообщение: RE: [HACKERS] Cached plans and statement generalization
Следующее
От: David Rowley
Дата:
Сообщение: plan_cache_mode and postgresql.conf.sample