Re: Function to kill backend

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Function to kill backend
Date: 2004-04-04 06:04:32
Message-ID: 406FA570.2030907@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Josh Berkus <josh(at)agliodbs(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message joseph speigle 2004-04-04 06:33:49 Re: thread_test.c problems
Previous Message Joe Conway 2004-04-04 05:10:51 Re: Better support for whole-row operations and composite