From: Yeb Havinga <yebhavinga@gmail.com>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: 10K vs 15k rpm for analytics
Date: Wed, 03 Mar 2010 10:45:13 +0100
Message-ID: <4B8E2FA9.4010109@gmail.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.
>
>
> 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.
It sounds like you have a lot of hardware around - my guess it would be
worthwhile to do a test setup with one server hooked up with two 3ware
controllers. Also, I am not sure if it is wise to put the WAL on the
same logical disk as the indexes, but that is maybe for a different
thread (unwise to mix random and sequential io and also the wal has
demands when it comes to write cache).
regards,
Yeb Havinga
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: yebhavinga@gmail.com, lists@stringsutils.com
Subject: Re: 10K vs 15k rpm for analytics
In-Reply-To: <4B8E2FA9.4010109@gmail.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