Re: Process wakeups when idle and power consumption

A.M. <agentm@themactionfaction.com>

From: "A.M." <agentm@themactionfaction.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-05-05T20:49:25Z
Lists: pgsql-hackers
On May 5, 2011, at 4:08 PM, Alvaro Herrera wrote:

> Excerpts from Peter Geoghegan's message of jue may 05 16:49:25 -0300 2011:
> 
>> I'll need to take a look at statistics, autovacuum and Logger
>> processes too, to see if they present more subtle opportunities for
>> reduced idle power consumption.
> 
> More subtle?  Autovacuum wakes up once per second and it could sleep a
> lot longer if it weren't for the loop that checks for signals.  I think
> that could be improved a lot.

Could kqueue be of use here? Non-kqueue-supporting platforms could always fall back to the existing select().

Cheers,
M