Re: Server instrumentation for 8.1

On Thu, May 12, 2005 at 10:55:22AM +0200, Magnus Hagander wrote:

> Not kill -9. Kill -9 is "safe" because it causes a complete restart of
> the postmaster (it's the same as a backend crash, really). Kill -INT is
> also safe, because it does a simlpe query cancel.

Hmm, would it be possible to use another signal for "cancel the current
query and enter a state where no queries are accepted"? That would mean
driving the backend to a known idle state, allowing further action to
end the connection. From the client perspective, the connection is no
longer useful anyway, so he can only disconnect.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)