Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Mon, Jan 11, 2010 at 1:13 PM, Dusek, Bob <rd185032@xxxxxxx> wrote: >> I haven't been involved in any benchmarking of PG8 with fsync=off, but we certainly did it with PG 7.4. fsync=0ff, for our purposes, was MUCH faster. > And many changes have been made since then to make fsyncing much > faster. You may be grinding the valves on a 2009 Ferrari because > pappy used to have to do it on his 1958 pickup truck here. Perhaps more to the point, synchronous_commit can get most of the same speedup with much less risk to your database. You really owe it to yourself to redo that benchmarking with a recent PG release. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
