--On 7. Mai 2010 19:49:15 -0400 Tom Lane <t...@sss.pgh.pa.us> wrote:
Bernd Helmle <maili...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers