Re: Redesigning checkpoint_segments - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: Redesigning checkpoint_segments
Date
Msg-id CAAZKuFahzEoF-1dtRrs0CbZHD-GgsTbSoW-=drxOUGA6NFJNfw@mail.gmail.com
Whole thread Raw
In response to Re: Redesigning checkpoint_segments  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
On Wed, Jun 5, 2013 at 10:27 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>
> On 6/5/2013 10:07 PM, Daniel Farina wrote:
>>
>>
>> If I told you there were some of us who would prefer to attenuate the
>> rate that things get written rather than cancel or delay archiving for
>> a long period of time, would that explain the framing of the problem?
>
>
> I understand that based on what you said above.
>
>
>> Or, is it that you understand that's what I want, but find the notion
>> of such a operation hard to relate to?
>
>
> I think this is where I am at. To me, you don't attenuate the rate that
> things get written, you fix the problem in needing to do so. The problem is
> one of provisioning. Please note that I am not suggesting there aren't
> improvements to be made, there absolutely are. I just wonder if we are
> looking in the right place (outside of some obvious badness like the PANIC
> running out of disk space).

Okay, well, I don't see the fact that the block device is faster than
the archive command as a "problem," it's just an artifact of the
ratios of performance of stuff in the system.  If one views archives
as a must-have, there's not much other choice than to attenuate.

An alternative is to buy a slower block device.  That'd accomplish the
same effect, but it's a pretty bizarre and heavyhanded way to go about
it, and not easily adaptive to, say, if I made the archive command
faster (in my case, I well could, with some work).

So, I don't think it's all that unnatural to allow for the flexibility
of a neat attenuation technique, and it's pretty important too.
Methinks.  Disagree?

Final thought: I can't really tell users to knock off what they're
doing on a large scale.  It's better to not provide abrupt changes in
service (like crashing or turning off everything for extended periods
while the archive uploads).  So, smoothness and predictability is
desirable.



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Redesigning checkpoint_segments
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Redesigning checkpoint_segments