Re: 3ware vs. MegaRAID

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: Ireneusz Pluta <ipluta(at)wp(dot)pl>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 3ware vs. MegaRAID
Date: 2010-04-08 06:13:32
Message-ID: 4BBD740C.7020308@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Carey wrote:
> * Change the linux 'readahead' block device parameter to at least 4MB (8192, see blockdev --setra) -- I don't know if there is a FreeBSD equivalent.
>
I haven't tested them, but 3ware gives suggestions at
http://www.3ware.com/kb/Article.aspx?id=14852 for tuning their cards
properly under FreeBSD. You cannot get good sequential read performance
from 3ware's cards without doing something about this at the OS level;
the read-ahead on the card itself is minimal and certainly a bottleneck.

As for your comments about drives being faster at the front than the
end, the zcav tool that comes with bonnie++ is a good way to plot that
out, rather than having to split partitions up and do a bunch of manual
testing.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sabin Coanda 2010-04-08 06:29:07 Re: How check execution plan of a function
Previous Message Greg Smith 2010-04-08 06:08:05 Re: Occasional giant spikes in CPU load