Re: [PERFORM] availability of SATA vendors

2006-11-26 Thread Jim C. Nasby
On Wed, Nov 22, 2006 at 09:02:04AM -0800, Jeff Frost wrote: A valid question. Does the caching raid controller negate the desire to separate pg_xlog from PGDATA? Theoretically, yes. But I don't think I've seen any hard numbers from testing. -- Jim Nasby

Re: [PERFORM] availability of SATA vendors

2006-11-26 Thread Jim C. Nasby
On Wed, Nov 22, 2006 at 04:35:37PM -0500, Bucky Jordan wrote: While I'm at it, if I have time I'll run pgbench with pg_log on a separate RAID1, and one with it on a RAID10x6, but I don't know how useful those results will be. Very, but only if the controller has write-caching enabled. For

Re: [PERFORM] availability of SATA vendors

2006-11-23 Thread Arjen van der Meijden
Hi Luke, I forgot about that article, thanks for that link. That's indeed a nice overview of (in august) recent controllers. The Areca 1280 in that test (and the results I linked to earlier) is a pre-production model, so it might actually perform even better than in that test. We've been

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Bucky Jordan
-Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-performance- [EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent: Tuesday, November 21, 2006 9:38 PM To: Jeff Frost Cc: Luke Lonergan; pgsql-performance@postgresql.org Subject: Re: [PERFORM] availability of SATA vendors Don't count

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Jeff Frost
On Wed, 22 Nov 2006, Bucky Jordan wrote: Dells (at least the 1950 and 2950) come with the Perc5, which is basically just the LSI MegaRAID. The units I have come with a 256MB BBU, I'm not sure if it's upgradeable, but it looks like a standard DIMM in there... I posted some dd and bonnie++

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Joshua D. Drake
On Wed, 2006-11-22 at 08:36 -0800, Jeff Frost wrote: On Wed, 22 Nov 2006, Bucky Jordan wrote: Dells (at least the 1950 and 2950) come with the Perc5, which is basically just the LSI MegaRAID. The units I have come with a 256MB BBU, I'm not sure if it's upgradeable, but it looks like a

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Jeff Frost
On Wed, 22 Nov 2006, Joshua D. Drake wrote: I could only find the 6 disk RAID5 numbers in the archives that were run with bonnie++1.03. Have you run the RAID10 tests since? Did you settle on 6 disk RAID5 or 2xRAID1 + 4XRAID10? Why not 6 drive raid 10? IIRC you need 4 to start RAID 10 but

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Arjen van der Meijden
Jeff, You can find some (Dutch) results here on our website: http://tweakers.net/reviews/647/5 You'll find the AMCC/3ware 9550SX-12 with up to 12 disks, Areca 1280 and 1160 with up to 14 disks and a Promise and LSI sata-raid controller with each up to 8 disks. Btw, that Dell Perc5 (sas) is

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Joshua D. Drake
On Wed, 2006-11-22 at 09:02 -0800, Jeff Frost wrote: On Wed, 22 Nov 2006, Joshua D. Drake wrote: I could only find the 6 disk RAID5 numbers in the archives that were run with bonnie++1.03. Have you run the RAID10 tests since? Did you settle on 6 disk RAID5 or 2xRAID1 + 4XRAID10?

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Scott Marlowe
On Wed, 2006-11-22 at 11:02, Jeff Frost wrote: On Wed, 22 Nov 2006, Joshua D. Drake wrote: I could only find the 6 disk RAID5 numbers in the archives that were run with bonnie++1.03. Have you run the RAID10 tests since? Did you settle on 6 disk RAID5 or 2xRAID1 + 4XRAID10? Why

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Bucky Jordan
I could only find the 6 disk RAID5 numbers in the archives that were run with bonnie++1.03. Have you run the RAID10 tests since? Did you settle on 6 disk RAID5 or 2xRAID1 + 4XRAID10? Unfortunately most of the tests were run with bonnie 1.9 since they were before I realized that people

Re: [PERFORM] availability of SATA vendors

2006-11-22 Thread Luke Lonergan
Arjen, As usual, your articles are excellent! Your results show again that the 3Ware 9550SX is really poor at random I/O with RAID5 and all of the Arecas are really good. 3Ware/AMCC have designed the 96xx to do much better for RAID5, but I've not seen results - can you get a card and test it?

Re: [PERFORM] availability of SATA vendors

2006-11-21 Thread Jeff Frost
On Fri, 17 Nov 2006, Luke Lonergan wrote: Currently, I'm looking at Penguin, HP and Sun (though Sun's store isn't working for me at the moment). Maybe I just need to order a Penguin and then buy the controller separately, but was hoping to get support from a single entity. Rackable or

Re: [PERFORM] availability of SATA vendors

2006-11-21 Thread Joshua D. Drake
ASAcomputers has been the most helpful of all the vendors so far, so thanks for point me at them. I know you've been posting results with the Areca and 3ware controllers, do you have a preference for one over the other? It seems that you can only get 256MB cache with the 3ware 9550SX and

Re: [PERFORM] availability of SATA vendors

2006-11-21 Thread Jeff Frost
On Tue, 21 Nov 2006, Joshua D. Drake wrote: ASAcomputers has been the most helpful of all the vendors so far, so thanks for point me at them. I know you've been posting results with the Areca and 3ware controllers, do you have a preference for one over the other? It seems that you can only

[PERFORM] availability of SATA vendors

2006-11-17 Thread Jeff Frost
I see many of you folks singing the praises of the Areca and 3ware SATA controllers, but I've been trying to price some systems and am having trouble finding a vendor who ships these controllers with their systems. Are you rolling your own white boxes or am I just looking in the wrong places?

Re: [PERFORM] availability of SATA vendors

2006-11-17 Thread Arjen van der Meijden
On 17-11-2006 18:45 Jeff Frost wrote: I see many of you folks singing the praises of the Areca and 3ware SATA controllers, but I've been trying to price some systems and am having trouble finding a vendor who ships these controllers with their systems. Are you rolling your own white boxes or

Re: [PERFORM] availability of SATA vendors

2006-11-17 Thread Ron
Contact Pogo Linux, www.pogolinux.com. I believe they OEM and VAR both Areca and 3ware in their systems. 3ware was bought out by AMCC, www.amcc.com Areca cards are distributed in NA by Tekram, www.tekram.com, and are available from them as solo items as well as in OEM storage systems.

Re: [PERFORM] availability of SATA vendors

2006-11-17 Thread Steve Atkins
On Nov 17, 2006, at 9:45 AM, Jeff Frost wrote: I see many of you folks singing the praises of the Areca and 3ware SATA controllers, but I've been trying to price some systems and am having trouble finding a vendor who ships these controllers with their systems. Are you rolling your own

Re: [PERFORM] availability of SATA vendors

2006-11-17 Thread Luke Lonergan
Jeff, On 11/17/06 11:45 AM, Jeff Frost [EMAIL PROTECTED] wrote: I see many of you folks singing the praises of the Areca and 3ware SATA controllers, but I've been trying to price some systems and am having trouble finding a vendor who ships these controllers with their systems. Are you