Re: Function to kill backend

Bruce,

> Someone already posted some pseudocode where they wanted to kill idle
> backends, perhaps as part of connection pooling.

I'm not talking about code.  I'm talking about a *reason*.

i.e.:  "I'm administrator of the blah-blah project.   We had a lot of trouble 
managing idle connections to PG because of blah-blah.   A function to kill 
off idle connctions would really help us becuase blah-blah-blah."

So far, all we've heard in favor of SIGTERM-by-PID are *hypothetical* cases.   
Now Tom's telling us that there is a real cost attached to having this 
feature.   Before we do it anyway, I want to be convinced that someone really 
needs it.  It is *not* our practice to add features "just because we can."

Otherwise, I'll stick by my assertion that idle connection management should 
be done in the middleware and NOT by psql.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco