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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, 506196(at)bugs(dot)debian(dot)org
Subject: Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)
Date: 2009-01-04 23:00:29
Message-ID: 819.1231110029@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lee McKeeman 2009-01-05 03:09:28 Status of issue 4593
Previous Message Alvaro Herrera 2009-01-04 21:22:19 Re: Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)