Re: Postgresql 9.0.6 Raid 5 or not please help.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgresql 9.0.6 Raid 5 or not please help.
Date: 2011-12-23 03:55:01
Message-ID: CAOR=d=0V9Xf3JRSaGzeRm274vGPXNgV2ur1UanEkd81QbpTjxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Dec 22, 2011 at 8:36 PM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
> I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on
> Windows 2003 64bit
> I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is
> bestter than 3 disk independent or not.
>
> Here is my pgbench -h %HOST% -p 5433 -U postgres -c 10 -T 1800 -s 10
> pgbench
>
> pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10  -T 1800  -s 10 pgbench
> Scale option ignored, using pgbench_branches table count = 10
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 10
> query mode: simple
> number of clients: 10
> number of threads: 1
> duration: 1800 s
> number of transactions actually processed: 775366
> tps = 430.736191 (including connections establishing)
> tps = 430.780400 (excluding connections establishing)

RAID 5 is aweful. Look up RAID 1E for 3 disks:
http://en.wikipedia.org/wiki/Non-standard_RAID_levels#RAID_1E

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-12-23 04:00:42 Re: Postgresql 9.0.6 Raid 5 or not please help.
Previous Message tuanhoanganh 2011-12-23 03:36:24 Postgresql 9.0.6 Raid 5 or not please help.