
> > Imho this write at logfile init time adds a substantial amount of IO,
> > that would better be avoided. If we really need this, it would imho 
> > be better to preallocate N logfiles and reuse them after checkpoint.
> 
> Already done.  See the WAL_FILES parameter.

I meant something else. I did not mean to write/format the logfile during 
checkpoint at all, but to reuse logfile number 0000000 for a later logfile.
Doing the format during checkpoint hurts even more, since that is the
time when the most writes occur, no ?

In my setup initdb, or startup, or whatever would preallocate N logfiles,
and those are reused round robin.

Andreas

Mon, 26 Feb 2001 16:51:33 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: AW: WAL does not recover gracefully from out-of-dis
	k-sp ace