Re: no universally correct setting for fsync - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: no universally correct setting for fsync
Date
Msg-id D9EB8B28CCC10C46B7DD3472@amenophis
Whole thread Raw
In response to Re: no universally correct setting for fsync  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: no universally correct setting for fsync
Next
From: hgonzalez@gmail.com
Date:
Subject: Re: [GENERAL] psql weird behaviour with charset encodings