Chris Gamache <cgg007(at)yahoo(dot)com> writes:
> Any clues on how to stop this runaway select without having to force the whole
> database down? This was started from an ODBC connection. Obviously the
> connection timed out... :)
> Can I kill -TERM 10906 ?
> Can I kill -KILL 10906 ?
kill -INT is a good idea, the others are bad ideas (and will in fact
lead to a database restart).
regards, tom lane