Re: Postgresql 9.0.6 Raid 5 or not please help.

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