Re: Server instrumentation for 8.1 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Server instrumentation for 8.1
Date
Msg-id 20050512131248.GA6998@surnet.cl
Whole thread Raw
In response to Re: Server instrumentation for 8.1  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: SQL_ASCII vs. 7-bit ASCII encodings
Next
From: "Magnus Hagander"
Date:
Subject: Re: Server instrumentation for 8.1