Re: hardare config question

From: Ron Peacetree <rjpeace(at)earthlink(dot)net>
To: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>, Vivek Khera <vivek(at)khera(dot)org>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: hardare config question
Date: 2006-04-28 18:19:23
Message-ID: 29786081.1146248363265.JavaMail.root@elwamui-royal.atl.sa.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

The best of all worlds is to use a HW RAID card with battery backed cache.

Then you can have both high performance and high reliability.

Benches suggest that the best such cards currently are the Areca cards which support up to 2GB of battery backed cache.

Ron

-----Original Message-----
>From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
>Sent: Apr 28, 2006 1:47 PM
>To: Vivek Khera <vivek(at)khera(dot)org>
>Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
>Subject: Re: [PERFORM] hardare config question
>
>It's also possible that the single SATA drive you were testing (or the
>controller it was attached to) is lying about fsync and performing write
>caching behind your back, whereas your new controller and drives are
>not.
>
>You'll find a lot more info on the archives of this list about it, but
>basically if your application is committing a whole lot of small
>transactions, then it will run fast (but not safely) on a drive which
>lies about fsync, but slower on a better disk subsystem which doesn't
>lie about fsync.
>
>Try running a test with fsync=off with your new equipment and if it
>suddenly starts running faster, then you know that's the problem.
>You'll either have a choice of losing all of your data the next time the
>system shuts down uncleanly but being fast, or of running slow, or of
>fixing the applications to use chunkier transactions.

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stumph 2006-04-28 18:36:21 Re: Worsening performance with 7.4 on flash-based system
Previous Message Mark Lewis 2006-04-28 17:47:21 Re: hardare config question