Re: Recomended FS
Mark Kirkwood <markir@paradise.net.nz>
From: Mark Kirkwood <markir@paradise.net.nz>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Ben-Nes Michael <miki@canaan.co.il>, Nick Burrett <nick@dsvr.net>, postgresql <pgsql-general@postgresql.org>, shridhar_daithankar@persistent.co.in
Date: 2003-11-10T07:49:03Z
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 > > > >