On Fri, Jan 13, 2012 at 12:02 PM, Reid Thompson <Reid.Thompson@ateb.com> wrote:
> The select query has been apparently orphaned by it's originating
> terminal or script or application. pg_/cancel/terminate/_backend both
> return t, but the query does not cancel/terminate. sigterm via the OS
> has no effect either.
You're sure you're killing the right backend (looks like the process
ID should be 32697, from what you posted)? What does strace tell you
the backend is doing?
> I'm not sure whether the vacuum is active, and just slow, or if it's
> spinning, or...? I've taken no action toward the vacuum process.
Above you talk about the "select query has been apparently orphaned".
Are you trying to kill off the vacuum or the SELECT query?
Josh