Re: cost-based vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cost-based vacuum
Дата
Msg-id 7752.1121088532@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: cost-based vacuum  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Simon Riggs <simon@2ndquadrant.com> writes:
>> I don't understand why this would be.  I don't think there
>> are any lock issues, and I don't see any obvious I/O issues.

> The ANALYZE commands hold read locks on the tables you wish to write to.

Unless there were more commands that Ian didn't show us, he's not taking
any locks that would conflict with ANALYZE.  So I don't believe this is
the explanation.

            regards, tom lane

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

Предыдущее
От: Ian Westmacott
Дата:
Сообщение: Re: cost-based vacuum
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Question