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

From Zeugswetter Andreas SB
Subject AW: WAL does not recover gracefully from out-of-disk-sp ace
Date
Msg-id 11C1E6749A55D411A9670001FA687963368236@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: WAL does not recover gracefully from out-of-disk-sp ace  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > Even with true fdatasync it's not obviously good for performance - it takes
> > too long time to write 16Mb files and fills OS buffer cache with trash-:(
> 
> True.  But at least the write is (hopefully) being done at a
> non-performance-critical time.

So you have non critical time every five minutes ?
Those platforms that don't have fdatasync won't profit anyway.
Even if the IO is done by postmaster the write to the disk has a severe
impact on concurrent other disk activity.
In a real 5 minutes checkpoint setup we are seriously talking about
48 Mb at least, or you risc foreground log creation. On systems I know,
that means 100% busying the disk for at least 8 seconds.

Andreas


pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: Internationalized error messages
Next
From: Tatsuo Ishii
Date:
Subject: Re: Internationalized error messages