Re: Reducing power consumption on idle servers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reducing power consumption on idle servers
Date
Msg-id 2316942.1674592779@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reducing power consumption on idle servers  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Reducing power consumption on idle servers
List pgsql-hackers
Thomas Munro <thomas.munro@gmail.com> writes:
> Yeah, I definitely want to fix it.  I just worry that 60s is so long
> that it also needs that analysis work to be done to explain that it's
> OK that we're a bit sloppy on noticing when to wake up, at which point
> you might as well go to infinity.

Yeah.  The perfectionist in me wants to say that there should be
explicit wakeups for every event of interest, in which case there's
no need for a timeout.  The engineer in me says "but what about bugs?".
Better a slow reaction than never reacting at all.  OTOH, then you
have to have a discussion about whether 60s (or any other
ice-cap-friendly value) is an acceptable response time even in the
presence of bugs.

It's kind of moot until we've reached the point where we can
credibly claim to have explicit wakeups for every event of
interest.  I don't think we're very close to that today, and
I do think we should try to get closer.  There may come a point
of diminishing returns though.

            regards, tom lane



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Making Vars outer-join aware
Next
From: Andrew Dunstan
Date:
Subject: Re: run pgindent on a regular basis / scripted manner