| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il>, Nick Burrett <nick(at)dsvr(dot)net>, postgresql <pgsql-general(at)postgresql(dot)org>, shridhar_daithankar(at)persistent(dot)co(dot)in |
| Subject: | Re: Recomended FS |
| Date: | 2003-11-10 07:49:03 |
| Message-ID: | 3FAF42EF.4030208@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Maybe it is a little late to be posting on this thread - but I was doing
pgbench runs with a Raid 0 ATA system and thought the results might be
interesting.
So here they are : pgbench -c 5 -t 1000 -s 5, median of 3 runs on a
Dual PIII 700 512Mb 2x7200 RPM ATA 133 Promise TX200
(same method / Pg configuration parameters as Scott's):
2 disk Raid0 W0
66 tps
2 disk Raid0 W1
220 tps
I was expecting a slightly better result for W0 (write caching off),
mind you the point could be made that you get about half the performance
of the SCSI system - for about half the price.
And the W1 result - that's fast, when (or if) that little power saving
capacitor arrives for these drives we could see performance, reliability
*and* economy....
regards
Mark
scott.marlowe wrote:
>
>MachineA Config1:
>141 tps
>
>MachineB Config1 W0:
>60 tps
>
>MachineB Config1 W1:
>112 tps
>
>MachineA Config2:
>101 tps
>
>MachineB Config2 W0:
>44 tps
>
>MachineB Config2 W1:
>135 tps
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Najib Abi Fadel | 2003-11-10 08:30:05 | SQL query not returning the value expected !!!!!!!!!!!!!!!!!! |
| Previous Message | Alex | 2003-11-10 07:20:21 | Re: Problem Deleting Referenced records |