Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)

Alvaro Herrera <alvherre@commandprompt.com> writes:
> I think we must blame bgwriter then.  I had a look at it some time ago
> to how hard would it be to remove the useless wakeups and concluded that
> it wasn't really worth the trouble.

I've got similar complaints in the RH/Fedora bugzilla.  It's hard to fix
in a portable way because of the lack of consistent select/poll
semantics across various platforms.  See my previous notes about the
lack of consistent EINTR behavior and whether we should really be using
SA_RESTART.

The short answer is "don't hold your breath".  It'd be nice to have a
plan for improving things though.

            regards, tom lane