On Thu, Oct 23, 2008 at 10:38 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> >> Any other better option that I could ask for ? > > Yes, more drives. 4 drives in a RAID10 is a good start. If you could > get 8 or 12 in one that's even better. > Note that for transactional databases SAS drives are usually noticeably better, but for reporting databases, SATA drives are generally fine, with 70-80% the sustained transfer rate at less than half the cost per megabyte. I'd recommend 8 SATA drives over 4 SAS drives for a reporting database. You'll spend about the same on twice the number of drives but you'll get much more storage, which is often useful when you need to work with large datasets. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
