Re: Function to kill backend - Mailing list pgsql-hackers

From Mike Mascari
Subject Re: Function to kill backend
Date
Msg-id 406FA570.2030907@mascari.com
Whole thread Raw
In response to Re: Function to kill backend  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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





pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Better support for whole-row operations and composite
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Function to kill backend