Re: performance config help - Mailing list pgsql-performance

From Tom Lane
Subject Re: performance config help
Date
Msg-id 18927.1263241557@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance config help  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Jan 11, 2010 at 1:13 PM, Dusek, Bob <rd185032@ncr.com> 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,
forour 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORMANCE] work_mem vs temp files issue
Next
From: "Kevin Grittner"
Date:
Subject: Re: performance config help