Re: help tuning queries on large database

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "peter royal" <peter(dot)royal(at)pobox(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: help tuning queries on large database
Date: 2006-01-09 19:01:43
Message-ID: BFE7F317.1A2C0%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Peter,

On 1/9/06 9:23 AM, "peter royal" <peter(dot)royal(at)pobox(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-01-09 20:35:58 Re: Memory Usage Question
Previous Message Tom Lane 2006-01-09 18:56:50 Re: 500x speed-down: Wrong query plan?