Re: How to terminate a query - Mailing list pgsql-general

From Josh Kupershmidt
Subject Re: How to terminate a query
Date
Msg-id w2v4ec1cf761004210709r79d22099tc21d48659964c064@mail.gmail.com
Whole thread Raw
In response to Re: How to terminate a query  (A B <gentosaker@gmail.com>)
List pgsql-general
On Wed, Apr 21, 2010 at 1:59 AM, A B <gentosaker@gmail.com> wrote:
>> Sometimes cancel_backend fails because there's no point where the code
>> checks for a cancel.
>
> What would such a point in the code look like?

For instance, if your backend is waiting on a socket call in libc, as
in this thread:
http://archives.postgresql.org/pgsql-general/2010-03/msg00663.php

Josh

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)
Next
From: Vick Khera
Date:
Subject: Re: Performance impact of hundreds of partitions