Matthew Wakeling wrote:
On Thu, 21 May 2009, Linos wrote:
i have to buy a new server and in the budget i have (small) i have
to select one of this two options:
-4 sas 146gb 15k rpm raid10.
-8 sas 146gb 10k rpm raid10.
It depends what you are doing. I think in most situations, the second
option is better, but there may be a few situations where the reverse is
true.
Basically, the first option will only be faster if you are doing lots of
seeking (small requests) in a single thread. As soon as you go
multi-threaded or are looking at sequential scans, you're better off
with more discs.
Since you have to share the disks with a file server, which might be heavily used, the 8-disk array will probably be better even if you're doing lots of seeking in a single thread.
Craig
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
