Unresponsive vacuum process - Mailing list pgsql-general

From Ed L.
Subject Unresponsive vacuum process
Date
Msg-id 200405190952.19681.pgsql@bluepolka.net
Whole thread Raw
Responses Re: Unresponsive vacuum process  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.  I know we need an upgrade; does anyone know how I can get
this VACUUM backend killed without taking down all the blocked/pending
UPDATEs and INSERTs?


pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: grant wildcard
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Restricted query