Re: Checkpoints occur too frequently

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org, markw(at)osdl(dot)org
Subject: Re: Checkpoints occur too frequently
Date: 2004-12-18 20:02:13
Message-ID: 1103400133.2893.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 2004-12-17 at 00:12, Tom Lane wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> > Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Charles Tse 2004-12-18 20:39:55 Jdbc3SimpleDataSource does not require the setting of password to access database
Previous Message Tom Lane 2004-12-18 17:22:35 Re: Postgresql 8.0 RC1 not using indexes