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