Re: performance config help - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: performance config help
Date
Msg-id dcc563d11001111216v34a71959jb32020ecf0071fc7@mail.gmail.com
Whole thread Raw
In response to Re: performance config help  ("Dusek, Bob" <rd185032@ncr.com>)
Responses Re: performance config help
List pgsql-performance
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.

pgsql-performance by date:

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