Re: Unresponsive vacuum process - Mailing list pgsql-general

From Tom Lane
Subject Re: Unresponsive vacuum process
Date
Msg-id 849.1085063752@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unresponsive vacuum process  (<wespvp@syntegra.com>)
List 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 by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Settings for autovacuum for batch uploading of data?
Next
From: Ken Godee
Date:
Subject: Re: list of open connections / terminate a connection?