Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Greg Smith
On Sat, 1 Mar 2008, Steve Poe wrote: 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've collected up many of the past list comments on this subject and put a summary at http://www.postgresqldocs.org/index.php/SCSI_vs._I

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Scott Marlowe
On Sun, Mar 2, 2008 at 9:11 PM, Vivek Khera <[EMAIL PROTECTED]> wrote: > > On Mar 2, 2008, at 2:37 AM, Steve Poe wrote: > > > 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

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Joshua D. Drake
On Sun, 2 Mar 2008 20:02:36 -0800 "Steve Poe" <[EMAIL PROTECTED]> wrote: > > It is these Dell arrays that I replaced with the Partners Data units > > last year. The dell boxes still have a year of warrantee on > > them... anyone interested in buying them from me, please make an > > offer :-) I

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Steve Poe
Vivek, I've had the same issue with the LSI MegaRAID card previously, I had to drop to U160. Since it happened with a brand new card and the local vendor's disc array, I've blamed the local vendor since this happened before. I've been leary of using Adaptec since they've had issues in the past.

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Vivek Khera
On Mar 2, 2008, at 2:37 AM, Steve Poe wrote: 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 ca

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Luke Lonergan
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 eigh

[PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Steve Poe
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 t

Re: [PERFORM] How to choose a disc array for Postgresql?

2008-03-02 Thread Joshua D. Drake
On Sat, 1 Mar 2008 23:37:37 -0800 "Steve Poe" <[EMAIL PROTECTED]> wrote: > 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 > se