Re: [PERFORM] RAID 0 not as fast as expected

2006-09-16 Thread Luke Lonergan
Bucky, On 9/15/06 11:28 AM, Bucky Jordan [EMAIL PROTECTED] wrote: What other file systems have you had good success with? Solaris would be nice, but it looks like I'm stuck running on FreeBSD (6.1, amd64) so UFS2 would be the default. Not sure about XFS on BSD, and I'm not sure at the moment

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-16 Thread Steinar H. Gunderson
On Sat, Sep 16, 2006 at 04:46:04PM -0700, Luke Lonergan wrote: Yes. What's pretty large? We've had to redefine large recently, now we're talking about systems with between 100TB and 1,000TB. Do you actually have PostgreSQL databases in that size range? /* Steinar */ -- Homepage:

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-16 Thread Joshua D. Drake
Steinar H. Gunderson wrote: On Sat, Sep 16, 2006 at 04:46:04PM -0700, Luke Lonergan wrote: Yes. What's pretty large? We've had to redefine large recently, now we're talking about systems with between 100TB and 1,000TB. Do you actually have PostgreSQL databases in that size range? No, they

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-15 Thread Luke Lonergan
. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent: Friday, September 15, 2006 12:01 AM To: Luke Lonergan Cc: Craig A. James; pgsql-performance@postgresql.org Subject: Re: [PERFORM] RAID 0 not as fast as expected Luke Lonergan wrote

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-15 Thread Bucky Jordan
When we first started working with Solaris ZFS, we were getting about 400-600 MB/s, and after working with the Solaris Engineering team we now get rates approaching 2GB/s. The updates needed to Solaris are part of the Solaris 10 U3 available in October (and already in Solaris Express, aka Solaris

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-15 Thread Luke Lonergan
Josh, On 9/14/06 8:47 PM, Joshua D. Drake [EMAIL PROTECTED] wrote: I've obtained 1,950 MB/s using Linux software RAID on SATA drives. With what? :) Sun X4500 (aka Thumper) running stock RedHat 4.3 (actually CentOS 4.3) with XFS and the linux md driver without lvm. Here is a summary of the

[PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Craig A. James
I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG dual-port SATA cards. (NB: I don't plan to run RAID 0 in production, probably RAID 10, so no need to comment on the failure rate of RAID 0.) I used this

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Joshua D. Drake
Craig A. James wrote: I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG dual-port SATA cards. (NB: I don't plan to run RAID 0 in production, probably RAID 10, so no need to comment on the failure rate of

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Alan Hodgson
On Thursday 14 September 2006 11:05, Craig A. James [EMAIL PROTECTED] wrote: I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG dual-port SATA cards. (NB: I don't plan to run RAID 0 in production, probably

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Craig A. James
Alan Hodgson wrote: On Thursday 14 September 2006 11:05, Craig A. James [EMAIL PROTECTED] wrote: I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG dual-port SATA cards. (NB: I don't plan to run RAID 0 in

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Scott Marlowe
On Thu, 2006-09-14 at 16:35, Craig A. James wrote: Alan Hodgson wrote: On Thursday 14 September 2006 11:05, Craig A. James [EMAIL PROTECTED] wrote: I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Luke Lonergan
Josh, On 9/14/06 11:49 AM, Joshua D. Drake [EMAIL PROTECTED] wrote: I am assuming linux here, Linux software raid 0 is known not to be super duper. I've obtained 1,950 MB/s using Linux software RAID on SATA drives. - Luke ---(end of

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Joshua D. Drake
Luke Lonergan wrote: Josh, On 9/14/06 11:49 AM, Joshua D. Drake [EMAIL PROTECTED] wrote: I am assuming linux here, Linux software raid 0 is known not to be super duper. I've obtained 1,950 MB/s using Linux software RAID on SATA drives. With what? :) - Luke -- === The

Re: [PERFORM] RAID 0 not as fast as expected

2006-09-14 Thread Joshua D. Drake
Luke Lonergan wrote: Josh, On 9/14/06 8:47 PM, Joshua D. Drake [EMAIL PROTECTED] wrote: I've obtained 1,950 MB/s using Linux software RAID on SATA drives. With what? :) Sun X4500 (aka Thumper) running stock RedHat 4.3 (actually CentOS 4.3) with XFS and the linux md driver without lvm.