Re: Time limit for a process to hold Content lock in Buffer Cache - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Time limit for a process to hold Content lock in Buffer Cache
Date
Msg-id CAHyXU0z_5VwMx_5e4AZt3uT5u7p+m5+73XK2x4VjoRJUEjMoVw@mail.gmail.com
Whole thread Raw
In response to Re: Time limit for a process to hold Content lock in Buffer Cache  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
On Thu, May 23, 2013 at 10:43 AM, Atri Sharma <atri.jiit@gmail.com> wrote:
>>
>> A little bit --- the timeout won't actually kill the query until the
>> next time control reaches a CHECK_FOR_INTERRUPTS macro that's not inside
>> a critical section.  We've had issues in the past with particular code
>> paths that failed to include such a check in a long-running loop, and
>> there might still be some left.  But by and large, it won't take very
>> long for the query to notice the interrupt.
>
>
> Right.I believe this is part of the standard way in which we handle
> interrupts,right? Making sure that we cancel a query when the backend
> is in a state to do so,not when the interrupt actually comes in,right?

yes. all non trivial parts of the code (in terms of time) must run the
interrupt check.  it basically just looks a the signal flag set by the
signal handler.

merlin



pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: Time limit for a process to hold Content lock in Buffer Cache
Next
From: Tom Lane
Date:
Subject: Re: Time limit for a process to hold Content lock in Buffer Cache