Re: no universally correct setting for fsync

Bernd Helmle <mailings@oopsware.de>

From: Bernd Helmle <mailings@oopsware.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, Andrew Dunstan <andrew@dunslane.net>, pgsql-hackers@postgresql.org
Date: 2010-05-08T00:16:23Z
Lists: pgsql-hackers

--On 7. Mai 2010 19:49:15 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Bernd Helmle <mailings@oopsware.de> writes:
>> I've recently even started to wonder if the performance gain with
>> fsync=off  is still that large on modern hardware. While testing large
>> migration  procedures to a new version some time ago (on an admitedly
>> fast storage) i  forgot here and then to turn it off, without a
>> significant degradation in  performance.
>
> That says to me either that you're using a battery-backed write cache,
> or your fsyncs don't really work (no write barriers or something like
> that).
>

Well, yes, BBU present and proven storage. Maybe i'm wrong, but it seems 
battery backed write caches aren't that seldom even in low end systems 
nowadays.

-- 
Thanks

	Bernd