Re: How to choose a disc array for Postgresql?

The Dell MD1000 is good. The most trouble you will have will be with the raid adapter - to get the best support I suggest trying to buy the dell perc 5e (also an LSI) - that way you'll get drivers that work and are supported.

Latest seq scan performance I've seen on redhat 5 is 400 MB/s on eight drives in RAID10 after setting linux max readahead to 16384 (blockdev --setra 16384) and 220 without.

----- Original Message -----
From: pgsql-performance-owner(at)postgresql(dot)org <pgsql-performance-owner(at)postgresql(dot)org>
To: pgsql-performance(at)postgresql(dot)org <pgsql-performance(at)postgresql(dot)org>
Sent: Sun Mar 02 02:37:37 2008
Subject: [PERFORM] How to choose a disc array for Postgresql?

I am moving our small business application
database application supporting
a 24/7 animal hospital to use 8.0.15 from
7.4.19 (it will not support 8.1, 8.2. or 8.3).

Now, we can choose a new a disc array. SATA
seems cheaper and you can get more discs but
I want to stay with SCSI. Any good reasons to
choose SATA over SCSI?

I need to consider a vendor for the new disc array (6-
to 8 discs). The local vendor (in the San Francisco Bay Area),
I've not been completely pleased with, so I am considering using
Dell storage connecting to an retail version LSI MegaRAID 320-2X card.

Anyone use any vendors that have been supportive of Postgresql?

Thanks for your help/feedback.

Steve