On 5/19/04 6:49 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> I have a 7.2.1 backend running VACUUM which appears to be blocking all other
>> processes. I have issued SIGTERM and SIGINT directly to that backend and
>> also killed the client process, but the VACUUM continues chewing up CPU and
>> blocking others.
>
> Hmph. AFAICS 7.2 does contain CHECK_FOR_INTERRUPT calls within all the
> major VACUUM loops, so it should respond to SIGINT in a reasonably
> timely fashion. 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.
Wes
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
