Re: [GENERAL] pg_xlog becomes extremely large during CREATE INDEX

2004-05-16 Thread Jeffrey W. Baker
On Fri, 2004-05-14 at 20:55, Tom Lane wrote: > Vivek Khera <[EMAIL PROTECTED]> writes: > > "TL" == Tom Lane <[EMAIL PROTECTED]> writes: > > TL> ... On looking at the code I see that it doesn't make any > > TL> attempt to prune future log segments after a decrease in > > TL> checkpoint_segments, so

Re: [GENERAL] pg_xlog becomes extremely large during CREATE INDEX

2004-05-13 Thread Tom Lane
"Jeffrey W. Baker" <[EMAIL PROTECTED]> 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

Re: [GENERAL] pg_xlog becomes extremely large during CREATE INDEX

2004-05-13 Thread Jeffrey W. Baker
On Thu, 2004-05-13 at 09:28, Tom Lane wrote: > "Jeffrey W. Baker" <[EMAIL PROTECTED]> 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. >

Re: [GENERAL] pg_xlog becomes extremely large during CREATE INDEX

2004-05-13 Thread Jeffrey W. Baker
On Thu, 2004-05-13 at 06:10, Tom Lane wrote: > "Jeffrey W. Baker" <[EMAIL PROTECTED]> writes: > > Oh sure, it's bleating. Apparently my computer is too fast: > > I don't think the checkpoint process is completing. > > > May 12 16:37:08 mistral postgres[506]: [174-1] LOG: server process (PID 164

Re: [GENERAL] pg_xlog becomes extremely large during CREATE INDEX

2004-05-13 Thread Tom Lane
"Jeffrey W. Baker" <[EMAIL PROTECTED]> writes: > Oh sure, it's bleating. Apparently my computer is too fast: I don't think the checkpoint process is completing. > May 12 16:37:08 mistral postgres[506]: [174-1] LOG: server process (PID 16403) was > terminated by signal 6 You need to find out w