Vitaly Belman <[EMAIL PROTECTED]> writes:
> Is there a way to kill a session in PostrgeSQL? I ran a bad query by
> mistake and I don't want to shut the whole database just to quit using
> the whole CPU.
ISTM what you really want is query cancel, not whole-session kill.
Try "kill -INT <pid-of-backend>".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
