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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
