Horton

Re: Function to kill backend

Mike Mascari <mascarm@mascari.com>

View thread
From: Mike Mascari <mascarm@mascari.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: josh@agliodbs.com, pgsql-hackers@postgresql.org
Date: 2004-04-04T06:04:32Z
Lists: pgsql-hackers 
Tom Lane wrote:

> Josh Berkus <josh@agliodbs.com> writes:
> 
>>Killing backends with runaway queries is a routine administrative
>>task.
> 
> 
> Cancelling runaway queries is a routine task.  I'm less convinced that a
> remote kill (ie SIGTERM) facility is such a great idea.

Of course, cancelling runaway queries on Oracle is only a necessity 
if the DBA hasn't made use of resource limits - PROFILEs. ;-)

Mike Mascari