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
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 |