Re: pg_xlog becomes extremely large during CREATE INDEX
От | Jeffrey W. Baker |
---|---|
Тема | Re: pg_xlog becomes extremely large during CREATE INDEX |
Дата | |
Msg-id | 1084466504.18162.28.camel@noodles обсуждение исходный текст |
Ответ на | Re: pg_xlog becomes extremely large during CREATE INDEX (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: