Re: Reduced power consumption in autovacuum launcher process - Mailing list pgsql-hackers

On 18.07.2011 18:32, Tom Lane wrote:
> Robert Haas<robertmhaas@gmail.com>  writes:
>> On Mon, Jul 18, 2011 at 10:35 AM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>>> A wakeup once every half hour would surely not be an issue from a power
>>> consumption standpoint.  However, I'm not sure I understand here: aren't
>>> we trying to remove the timeouts completely?
>
>> Well, in the case of the AV launcher, the issue is that the main loop
>> is timed by definition, cf. autovacuum_naptime, and the WaitLatch()
>> interface is apparently designed so that we can't sleep longer than 35
>> minutes.
>
> Hmm.  Well, it's not too late to rethink the WaitLatch API, if we think
> that that might be a significant limitation.

Right, we can easily change the timeout argument to be in milliseconds 
instead of microseconds.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com