Thread: XLogWrite: had to create new log file
should i worry about these DEBUGs in my log file? DEBUG: MoveOfflineLogs: remove 00000004000000B6 DEBUG: MoveOfflineLogs: remove 00000004000000B5 ... DEBUG: XLogWrite: had to create new log file - you probably should do checkpoints more often
Thomas T. Thai writes: > should i worry about these DEBUGs in my log file? > > DEBUG: MoveOfflineLogs: remove 00000004000000B6 > DEBUG: MoveOfflineLogs: remove 00000004000000B5 > ... > DEBUG: XLogWrite: had to create new log file - you probably should do > checkpoints more often No, but you probably should do checkpoints more often. ;-) The way I understand it, a "checkpoint" is when the server flushes the old log files (WAL files, not the message log). It does that automatically every few minutes, or when the log file has reached a certain size. If you get these messages then the latter case has happened, which is presumably a bit of a performance hit. Then if you do checkpoints more frequently these won't happen because the log files are flushed when idle. The documentation is admittedly lacking in that area. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
On Sat, 6 Jan 2001, Peter Eisentraut wrote: > Thomas T. Thai writes: > > > should i worry about these DEBUGs in my log file? > > > > DEBUG: MoveOfflineLogs: remove 00000004000000B6 > > DEBUG: MoveOfflineLogs: remove 00000004000000B5 > > ... > > DEBUG: XLogWrite: had to create new log file - you probably should do > > checkpoints more often > > No, but you probably should do checkpoints more often. ;-) > > The way I understand it, a "checkpoint" is when the server flushes the old > log files (WAL files, not the message log). It does that automatically > every few minutes, or when the log file has reached a certain size. If > you get these messages then the latter case has happened, which is > presumably a bit of a performance hit. Then if you do checkpoints more > frequently these won't happen because the log files are flushed when idle. > > The documentation is admittedly lacking in that area. ok that made sense as i'm running mnogosearch with 10 indexers going. now, here is a newbie question: how do i 'do chechpoints more often'? is there something i can run from cron or something?