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

From Tom Lane
Subject Re: Reduced power consumption in autovacuum launcher process
Date
Msg-id 16642.1311003159@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reduced power consumption in autovacuum launcher process  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Reduced power consumption in autovacuum launcher process
List pgsql-hackers
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.  Offhand I don't see that
it is, though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: [v9.1] sepgsql - userspace access vector cache
Next
From: "Kevin Grittner"
Date:
Subject: Re: FOR KEY LOCK foreign keys