Re: Feedback on getting rid of VACUUM FULL

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Feedback on getting rid of VACUUM FULL
Дата
Msg-id 603c8f070909170932o62feac52wcc25887b08d56fa7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feedback on getting rid of VACUUM FULL  (Hannu Krosing <hannu@2ndQuadrant.com>)
Список pgsql-hackers
On Thu, Sep 17, 2009 at 12:31 PM, Hannu Krosing <hannu@2ndquadrant.com> wrote:
>> Exactly.  The application is typically going to throw a "concurrent
>> update" type of error when this happens, and we don't want magic
>> background operations to cause that.
>
> Would'nt current VACUUM FULL or CLUSTER cause much more grief in this
> situation ?

No.  They take an exclusive lock on the table, so this situation can't
occur in those cases, which was Tom's point.

...Robert


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Feedback on getting rid of VACUUM FULL
Следующее
От: Robert Haas
Дата:
Сообщение: Re: opportunistic tuple freezing