Re: performance config help

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Dusek, Bob" <rd185032(at)ncr(dot)com>
Cc: Bob Dusek <redusek(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance config help
Date: 2010-01-11 20:16:45
Message-ID: dcc563d11001111216v34a71959jb32020ecf0071fc7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 11, 2010 at 1:13 PM, Dusek, Bob <rd185032(at)ncr(dot)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, 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-01-11 20:18:40 Re: [PERFORMANCE] work_mem vs temp files issue
Previous Message Dusek, Bob 2010-01-11 20:13:12 Re: performance config help