Re: Checkpoints occur too frequently - Mailing list pgsql-bugs

From Simon Riggs
Subject Re: Checkpoints occur too frequently
Date
Msg-id 1103400133.2893.5.camel@localhost.localdomain
Whole thread Raw
In response to Re: Checkpoints occur too frequently  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, 2004-12-17 at 00:12, Tom Lane wrote:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
> > Simon Riggs <simon@2ndquadrant.com> writes:
> >> I'd say no code changes for 8.0, now we know what's causing it. A doc
> >> patch to show the limit is probably just going to annoy the translators
> >> at this stage also.
>
> > We could adjust guc.c to limit checkpoint_segments to the range 1..255
> > without having to touch any translatable strings.  This isn't a
> > necessary change but it seems harmless ... any objections?
>
> Or we could just fix it.  After thinking a bit more, I realized that
> it's not hard to push the forced-checkpoint boundary out to 2^32
> segments instead of 255.  That should be enough to still any complaints.

Sorry for the delay in replying.

Thanks for considering this further.

If it can be fixed in 8.0, that would be good. If this means any risk or
non-portability, then I would defer.

--
Best Regards, Simon Riggs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 8.0 RC1 not using indexes
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1348: Wishlist: \pset expanded with value