Re: pg_xlog becomes extremely large during CREATE INDEX

On Thu, 2004-05-13 at 09:28, Tom Lane wrote:
> "Jeffrey W. Baker" <jwbaker@acm.org> writes:
> > Sorry, my last mail got cut off.  The server aborted because it couldn't
> > write the xlog.  Looks like I omitted this from my last mail:
>
> Selective quoting of the log output?  Naughty naughty.
>
> However, that still doesn't explain how you got into the current state.
> Had you once had checkpoint_segments set much higher than the current
> value of 24?  On looking at the code I see that it doesn't make any
> attempt to prune future log segments after a decrease in
> checkpoint_segments, so if a previous misconfiguration had allowed the
> number of future segments to get really large, that could be the root of
> the issue.

The database where this happened was freshly initialized and this was
one of its first operations.  I think I will write a small example
script so you can reproduce it locally.  Give me a few hours or so.

-jwb