Re: Process wakeups when idle and power consumption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Process wakeups when idle and power consumption
Date
Msg-id 28985.1304642730@sss.pgh.pa.us
Whole thread Raw
In response to Re: Process wakeups when idle and power consumption  (Peter Geoghegan <peter@2ndquadrant.com>)
List pgsql-hackers
Peter Geoghegan <peter@2ndquadrant.com> writes:
> On 5 May 2011 22:22, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> What that really means is that any WaitOnLatch call with a finite
>> timeout ought to be viewed with a jaundiced eye. �Ideally, we want them
>> all to be waiting for latch release and nothing else. �I'm concerned
>> that we're going to be moving towards some intermediate state where we
>> have WaitOnLatch calls with very long timeouts, because the longer the
>> timeout, the worse the problem gets on platforms that have the problem.
>> If you have say a 1-minute timeout, it's not difficult to believe that
>> you'll basically never wake up because of random signals resetting the
>> timeout.

> Unless all signal handlers for signals that we expect call SetLatch()
> anyway, as in this case.

It's signals that we don't expect that I'm a bit worried about here.

In any case, the bottom line is that having a timeout on WaitOnLatch
is a kludge, and we should try to avoid it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some surprising precedence behavior in PG's grammar
Next
From: Robert Haas
Date:
Subject: Re: Backpatching of "Teach the regular expression functions to do case-insensitive matching"