Re: BUG #5397: powertop reports excessive wakeups - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5397: powertop reports excessive wakeups
Date
Msg-id 20100331022238.GI3565@alvh.no-ip.org
Whole thread Raw
In response to BUG #5397: powertop reports excessive wakeups  ("Steve White" <Stevan_White@hotmail.com>)
List pgsql-bugs
Steve White wrote:

> This is a Samsung NC20.  The goal is to use this machine for occasional
> testing of a database, but to keep its power consumption minimal.
>
> Intel powertop reports the second biggest cause of wakeups (after the
> network device ath) is postgres:
>
> Top causes for wakeups
>   23.6% ( 11.7)D  postgres
>
> This is with a cleanly installed database, not being accessed at all.

Try raising autovacuum_naptime (or disabling autovac altogether).  There
are other background processes that wake up with some frequency; I think
bgwriter_delay and wal_writer_delay could be increased as well.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: "Steve White"
Date:
Subject: BUG #5397: powertop reports excessive wakeups
Next
From: Craig Ringer
Date:
Subject: Re: BUG #5395: UPDATE on shutdown overwrites table