Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: AW: WAL does not recover gracefully from out-of-disk-sp ace
Date
Msg-id 26233.983201996@sss.pgh.pa.us
Whole thread Raw
In response to AW: WAL does not recover gracefully from out-of-disk-sp ace  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Tree view 
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> 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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Timothy H. Keitt"
Date:
Subject: Re: offset and limit in update and subselect
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: WAL does not recover gracefully from out-of-dis k-sp ace