From: Francisco Reyes <lists@stringsutils.com>
To: 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 16:28:35 -0500
Message-ID: <cone.1267565315.87109.32557.1000@shelca> (raw)
References: <cone.1267562557.293175.32557.1000@shelca>
<4B8D7A6C.3010304@gmail.com>
Yeb Havinga writes:
> With 24 drives it'll probably be the controller that is the limiting
> factor of bandwidth.
Going with a 3Ware SAS controller.
> Our HP SAN controller with 28 15K drives delivers
> 170MB/s at maximum with raid 0 and about 155MB/s with raid 1+0.
Already have simmilar machine in house.
With RAID 1+0 Bonne++ reports around 400MB/sec sequential read.
> go for the 10K drives and put the saved money towards the controller (or
> maybe more than one controller).
Have some external enclosures with 16 15Krpm drives. They are older 15K
rpms, but they should be good enough.
Since the 15K rpms usually have better Transanctions per second I will
put WAL and indexes in the external enclosure.
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: lists@stringsutils.com, yebhavinga@gmail.com
Subject: Re: 10K vs 15k rpm for analytics
In-Reply-To: <cone.1267565315.87109.32557.1000@shelca>
* 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