Re: XLogWrite: had to create new log file
От | Thomas T. Thai |
---|---|
Тема | Re: XLogWrite: had to create new log file |
Дата | |
Msg-id | Pine.NEB.4.21.0101061328360.23128-100000@ns01.minnesota.com обсуждение исходный текст |
Ответ на | Re: XLogWrite: had to create new log file (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: