Re: Need for speed 2

From: Kelly Burkhart <kelly(at)tradebotsystems(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need for speed 2
Date: 2005-08-25 19:00:22
Message-ID: 1124996422.6969.47.camel@krb06.tradebot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Lazarus 2005-08-25 19:24:38 What *_mem to increase when running CLUSTER
Previous Message Merlin Moncure 2005-08-25 17:30:48 Re: Need for speed 2