Re: [HACKERS] Function to kill backend - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] Function to kill backend
Date
Msg-id 7921.1090709461@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Function to kill backend  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Function to kill backend  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> OK, I see your point.  Can anyone remember why this was needed?  I
> remember Magnus wanted query cancel, but what was the logic for session
> termination?

I think the argument for it went along the lines of "what if you've got
a misbehaving client that continually issues expensive queries, so
canceling any one query doesn't help?"  I found this unconvincing, as
a client that obstreperous might simply reconnect and start issuing the
same queries again; so having a session-kill tool doesn't really get you
much further.  I recall being voted down though ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Function to kill backend
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Function to kill backend