Re: How to terminate a query

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: A B <gentosaker(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to terminate a query
Date: 2010-04-21 14:09:37
Message-ID: w2v4ec1cf761004210709r79d22099tc21d48659964c064@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 21, 2010 at 1:59 AM, A B <gentosaker(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-04-21 14:20:20 Re: Performance impact of hundreds of partitions
Previous Message Scott Marlowe 2010-04-21 13:17:41 Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)