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: Wed, 03 Mar 2010 08:51:56 -0500
Message-ID: <cone.1267624316.4148.32557.1000@shelca> (raw)
References: <cone.1267562557.293175.32557.1000@shelca>
<4B8D7A6C.3010304@gmail.com>
<cone.1267565315.87109.32557.1000@shelca>
<4B8E2FA9.4010109@gmail.com>
Yeb Havinga writes:
> controllers. Also, I am not sure if it is wise to put the WAL on the
> same logical disk as the indexes,
If I only have two controllers would it then be better to put WAL on the
first along with all the data and the indexes on the external? Specially
since the external enclosure will have 15K rpm vs 10K rpm in the internal.
> thread (unwise to mix random and sequential io and also the wal has
> demands when it comes to write cache).
Thanks for pointing that out.
With any luck I will actually be able to do some tests for the new hardware.
The curernt one I literaly did a few hours stress test and had to put in
production right away.
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.1267624316.4148.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