Re: Recomended FS - Mailing list pgsql-general

From Mark Kirkwood
Subject Re: Recomended FS
Date
Msg-id 3FAF42EF.4030208@paradise.net.nz
Whole thread Raw
In response to Re: Recomended FS  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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
>
>
>
>



pgsql-general by date:

Previous
From: Alex
Date:
Subject: Re: Problem Deleting Referenced records
Next
From: "frank_lupo"
Date:
Subject: drop user question