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

From Tom Lane
Subject Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)
Date
Msg-id 819.1231110029@sss.pgh.pa.us
Whole thread Raw
In response to Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)
Next
From: "Lee McKeeman"
Date:
Subject: Status of issue 4593