Re: Autovacuum cancellation

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Autovacuum cancellation
Дата
Msg-id 4721B419.1070700@enterprisedb.com
обсуждение исходный текст
Ответ на Autovacuum cancellation  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum cancellation  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Autovacuum cancellation  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Alvaro Herrera wrote:
> /*
>  * Look for a blocking autovacuum. There will only ever
>  * be one, since the autovacuum workers are careful
>  * not to operate concurrently on the same table.
>  */

I think that's a bit unaccurate. You could have multiple autovacuum
workers operating on different tables participating in a deadlock. The
reason that can't happen is that autovacuum never holds a lock while
waiting for another.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Fix ecpg dependency on postgres.h
Следующее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: [HACKERS] Including Snapshot Info with Indexes