On Fri, 2004-12-17 at 00:12, Tom Lane wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
> > Simon Riggs <[EMAIL PROTECTED]> 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
Tom Lane <[EMAIL PROTECTED]> writes:
> Simon Riggs <[EMAIL PROTECTED]> 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_segm
Tom,
> 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?
+1 in favor.
We'll need to change the value in runtime-config.sgml and in pg_settings, too.
Simon Riggs <[EMAIL PROTECTED]> 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 t
On Tue, 2004-12-14 at 23:31, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > DEBUG1 messages showed that there is an apparent limit of 255 xlog files
> > per checkpoint -
>
> The volume-based checkpoint trigger code is
>
> if (IsUnderPostmaster &&
>
Simon Riggs <[EMAIL PROTECTED]> writes:
> DEBUG1 messages showed that there is an apparent limit of 255 xlog files
> per checkpoint -
The volume-based checkpoint trigger code is
if (IsUnderPostmaster &&
(openLogId != RedoRecPtr.xlogid ||
op
Recent OSDL test reports for 8.0RC1 show that checkpoints occur too
frequently for higher settings of checkpoint_segments and
checkpoint_timeout. This is incorrect according to the manual, and the
intention of the current implementation from examining the code.
Early tests showed that checkpoints
