| From: | tuanhoanganh <hatuan05(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Postgresql 9.0.6 Raid 5 or not please help. |
| Date: | 2011-12-23 03:36:24 |
| Message-ID: | CAJg-yaNFnhs9unUFvpUypoi-n6C9cja+yrJ+9muEGYkpuZQkgA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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)
Sorry for my English.
Tuan Hoang Anh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2011-12-23 03:55:01 | Re: Postgresql 9.0.6 Raid 5 or not please help. |
| Previous Message | Havasvölgyi Ottó | 2011-12-22 09:58:57 | Re: Dramatic change in memory usage with version 9.1 |