From: Luke Lonergan <llonergan@greenplum.com>
To: peter royal <peter.royal@pobox.com>
To: pgsql-performance@postgresql.org
Subject: Re: help tuning queries on large database
Date: Mon, 09 Jan 2006 11:01:43 -0800
Message-ID: <BFE7F317.1A2C0%llonergan@greenplum.com> (raw)
In-Reply-To: <414814B8-556C-47DB-B364-A5A681CC3522@pobox.com>
Peter,
On 1/9/06 9:23 AM, "peter royal" <peter.royal@pobox.com> wrote:
> This is a 2-disk RAID0
Your 2-disk results look fine - what about your 8-disk results?
Given that you want to run in production with RAID10, the most you should
expect is 2x the 2-disk results using all 8 of your disks. If you want the
best rate for production while preserving data integrity, I recommend
running your Areca in RAID5, in which case you should expect 3.5x your
2-disk results (7 drives). You can assume you'll get that if you use XFS +
readahead. OTOH - I'd like to see your test results anyway :-)
- Luke
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: llonergan@greenplum.com, peter.royal@pobox.com
Subject: Re: help tuning queries on large database
In-Reply-To: <BFE7F317.1A2C0%llonergan@greenplum.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