Re: What to do about a vacuum...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What to do about a vacuum...
Дата
Msg-id 4030.1028910669@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What to do about a vacuum...  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-admin
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Fri, Aug 09, 2002 at 11:20:06AM -0400, Tom Lane wrote:
>> You sure you sigint'ed the right process?  I can't see that VACUUM could
>> take more than a few seconds to respond to a cancel --- it checks before
>> moving onto each new page.

> Will vacuum respond to SIGINT if it's blocked waiting for a
> transaction to commit?

I believe so --- that's just a special case of waiting for a lock, and
SIGINT should be able to interrupt anything that's waiting for a lock.

            regards, tom lane

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: What to do about a vacuum...
Следующее
От: Jie Liang
Дата:
Сообщение: Another possible bug in pg_restore