Re: Need for speed 2 - Mailing list pgsql-performance

From Kelly Burkhart
Subject Re: Need for speed 2
Date
Msg-id 1124996422.6969.47.camel@krb06.tradebot.com
Whole thread Raw
In response to Re: Need for speed 2  (Ron <rjpeace@earthlink.net>)
Responses Re: Need for speed 2
List pgsql-performance
On Thu, 2005-08-25 at 11:16 -0400, Ron wrote:
> ># - Settings -
> >
> >fsync = false                   # turns forced synchronization on or off
> >#wal_sync_method = fsync        # the default varies across platforms:
> >                                 # fsync, fdatasync, open_sync, or
>
> I hope you have a battery backed write buffer!

Battery backed write buffer will do nothing here, because the OS is
taking it's sweet time flushing to the controller's battery backed write
buffer!

Isn't the reason for batter backed controller cache to make fsync()s
fast?

-K

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Need for speed 2
Next
From: Andrew Lazarus
Date:
Subject: What *_mem to increase when running CLUSTER