Re: XLogWrite: had to create new log file

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/