| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | wespvp(at)syntegra(dot)com |
| Cc: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Unresponsive vacuum process |
| Date: | 2004-05-20 14:35:52 |
| Message-ID: | 849.1085063752@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<wespvp(at)syntegra(dot)com> writes:
> On 5/19/04 6:49 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Godee | 2004-05-20 14:41:22 | Re: list of open connections / terminate a connection? |
| Previous Message | Matthew T. O'Connor | 2004-05-20 14:30:22 | Re: Settings for autovacuum for batch uploading of data? |