Re: Unresponsive vacuum process

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unresponsive vacuum process
Дата
Msg-id 849.1085063752@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Unresponsive vacuum process  (<wespvp@syntegra.com>)
Список pgsql-general
<wespvp@syntegra.com> writes:
> On 5/19/04 6:49 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> ...  I'd think it was blocked on someone else's lock if it
>> weren't that you say it's still consuming CPU.  Can you attach to the
>> troublesome backend with gdb and get a stack trace to show where it is?

> I've had 7.4.1 take up to an hour and a half to abort a vacuum after a
> SIGNIT.

The request for information still stands.  I can't do a thing with
undetailed anecdotes.

            regards, tom lane

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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Settings for autovacuum for batch uploading of data?
Следующее
От: Ken Godee
Дата:
Сообщение: Re: list of open connections / terminate a connection?