AW: AW: WAL does not recover gracefully from out-of-dis k-sp ace - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: WAL does not recover gracefully from out-of-dis k-sp ace
Date
Msg-id 11C1E6749A55D411A9670001FA687963368216@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: WAL does not recover gracefully from out-of-disk-sp ace
Next
From: The Hermit Hacker
Date:
Subject: Release in 2 weeks ...