Scott Marlowe <[email protected]> writes:
> On Mon, Jan 11, 2010 at 1:13 PM, Dusek, Bob <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
