Re: What to do about a vacuum...

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: What to do about a vacuum...
Дата
Msg-id 20020809113651.A7239@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: What to do about a vacuum...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: What to do about a vacuum...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Fri, Aug 09, 2002 at 11:20:06AM -0400, Tom Lane wrote:
> "Robert M. Meyer" <rmeyer@installs.com> writes:
> > Well, 'kill -INT pid' doesn't seem to have worked.  This is 7.2.1.  We
> > really don't want to whack the system but we need to get back online...
>
> 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?

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


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

Предыдущее
От: "Robert M. Meyer"
Дата:
Сообщение: Re: What to do about a vacuum...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What to do about a vacuum...