From: Greg Smith <greg@2ndquadrant.com>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Yeb Havinga <yebhavinga@gmail.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: 10K vs 15k rpm for analytics
Date: Tue, 02 Mar 2010 18:44:20 -0500
Message-ID: <4B8DA2D4.8000501@2ndquadrant.com> (raw)
In-Reply-To: <cone.1267565315.87109.32557.1000@shelca>
References: <cone.1267562557.293175.32557.1000@shelca>
<4B8D7A6C.3010304@gmail.com>
<cone.1267565315.87109.32557.1000@shelca>
Francisco Reyes wrote:
> Going with a 3Ware SAS controller.
> Already have simmilar machine in house.
> With RAID 1+0 Bonne++ reports around 400MB/sec sequential read.
Increase read-ahead and I'd bet you can add 50% to that easy--one area
the 3Ware controllers need serious help, as they admit:
http://www.3ware.com/kb/article.aspx?id=11050 Just make sure you ignore
their dirty_ratio comments--those are completely the opposite of what
you want on a database app. Still seems on the low side though.
Short stroke and you could probably chop worst-case speeds in half too,
on top of that.
Note that 3Ware's controllers have seriously limited reporting on drive
data when using SAS drives because they won't talk SMART to them:
http://www.3ware.com/KB/Article.aspx?id=15383 I consider them still a
useful vendor for SATA controllers, but would never buy a SAS solution
from them again until this is resolved.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, lists@stringsutils.com, yebhavinga@gmail.com
Subject: Re: 10K vs 15k rpm for analytics
In-Reply-To: <4B8DA2D4.8000501@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox