Re: [PERFORM] RAID Controllers

2011-08-23 Thread Greg Smith
On 08/23/2011 06:42 PM, David Boreham wrote: I took a look at Areca. The fan on the controller board is a big warning signal for me (those fans are in my experience the single most unreliable component ever used in computers). I have one of their really early/cheap models here, purchased in ear

Re: [PERFORM] RAID Controllers

2011-08-23 Thread Scott Marlowe
On Tue, Aug 23, 2011 at 4:42 PM, David Boreham wrote: > On 8/22/2011 10:55 PM, Scott Marlowe wrote: >> >> If you're running linux and thus stuck with the command line on the >> LSI, I'd recommend anything else.  MegaRAID is the hardest RAID >> control software to use I've ever seen.  If you can sp

Re: [PERFORM] RAID Controllers

2011-08-23 Thread David Boreham
On 8/22/2011 10:55 PM, Scott Marlowe wrote: If you're running linux and thus stuck with the command line on the LSI, I'd recommend anything else. MegaRAID is the hardest RAID control software to use I've ever seen. If you can spring for the money, get the Areca 1680: http://www.newegg.com/Produ

Re: [PERFORM] RAID Controllers

2011-08-23 Thread Alan Hodgson
On August 22, 2011 09:55:33 PM Scott Marlowe wrote: > > If you're running linux and thus stuck with the command line on the > LSI, I'd recommend anything else. MegaRAID is the hardest RAID > control software to use I've ever seen. If you can spring for the > money, get the Areca 1680: > http://ww

Re: [PERFORM] RAID Controllers

2011-08-23 Thread David Boreham
On 8/23/2011 5:14 AM, Robert Schnabel wrote: I'm by no means an expert but it seems to me if you're going to choose between two 6 GB/s cards you may as well put SAS2 drives in. I have two Adaptec 6445 cards in one of my boxes and several other Adaptec series 5 controllers in others. They su

Re: [PERFORM] RAID Controllers

2011-08-23 Thread Robert Schnabel
On 8/22/2011 9:42 PM, David Boreham wrote: I'm buying a bunch of new machines (all will run an application that heavily writes to PG). These machines will have 2 spindle groups in a RAID-1 config. Drives will be either 15K SAS, or 10K SATA (I haven't decided if it is better to buy the faster dri

Re: [PERFORM] RAID Controllers

2011-08-22 Thread Scott Marlowe
On Mon, Aug 22, 2011 at 8:42 PM, David Boreham wrote: > > I'm buying a bunch of new machines (all will run an application that heavily > writes to PG). These machines will have 2 spindle groups in a RAID-1 config. > Drives will be either 15K SAS, or 10K SATA (I haven't decided if it is > better >

[PERFORM] RAID Controllers

2011-08-22 Thread David Boreham
I'm buying a bunch of new machines (all will run an application that heavily writes to PG). These machines will have 2 spindle groups in a RAID-1 config. Drives will be either 15K SAS, or 10K SATA (I haven't decided if it is better to buy the faster drives, or drives that are identical to the o

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread PFC
You say that like you don't mind having PCI in a server whose job is to perform massive query over large data sets. I am in my 4th week at a new job. Trying to figure what I am working with. LOOL, ok, hehe, not exactly the time to have a "let's change everything" fit ;) From what I

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread James Mansion
PFC wrote: PCI limits you to 133 MB/s (theoretical), actual speed being around 100-110 MB/s. Many servers do have more than one bus. You have to process that data too so its not going to be as much of a limit as you are suggesting. It may be possible to stream a compressed data file to th

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread Vivek Khera
On May 12, 2008, at 11:24 PM, Francisco Reyes wrote: Any PCI controller you have had good experience with? How any other PCI-X/PCI-e controller that you have had good results? The LSI controllers are top-notch, and always my first choice. They have PCI-X and PCI-e versions. -- Sent via

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread Vivek Khera
On May 12, 2008, at 10:04 PM, Francisco Reyes wrote: Adaptec 2120 SCSI controller (64MB of cache). The servers have mostly have 12 drives in RAID 10. We are going to redo one machine to compare RAID 10 vs RAID 50. Mostly to see if the perfomance is close, the space gain may be usefull.

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread Merlin Moncure
On Tue, May 13, 2008 at 8:00 AM, Francisco Reyes <[EMAIL PROTECTED]> wrote: > PFC writes: > > > >You say that like you don't mind having PCI in a server whose job > is to perform massive query over large data sets. > > > > I am in my 4th week at a new job. Trying to figure what I am worki

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread Francisco Reyes
PFC writes: You say that like you don't mind having PCI in a server whose job is to perform massive query over large data sets. I am in my 4th week at a new job. Trying to figure what I am working with. From what I see I will likely get as much improvement from new hardware as from re-doing

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread PFC
Will it pay to go to a controller with higher memory for existing machines? The one machine I am about to redo has PCI which seems to somewhat limit our options. Urgh. You say that like you don't mind having PCI in a server whose job is to perform massive query over large data s

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-13 Thread Scott Marlowe
On Mon, May 12, 2008 at 8:04 PM, Francisco Reyes <[EMAIL PROTECTED]> wrote: > Inheritted a number of servers and I am starting to look into the hardware. > > So far what I know from a few of the servers > Redhat servers. > 15K rpm disks, 12GB to 32GB of RAM. > Adaptec 2120 SCSI controller (64MB of

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Greg Smith
On Mon, 12 May 2008, Francisco Reyes wrote: We are going to redo one machine to compare RAID 10 vs RAID 50. Mostly to see if the perfomance is close, the space gain may be usefull. Good luck with that, you'll need it. Will it pay to go to a controller with higher memory for existing machine

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
Francisco Reyes wrote: Joshua D. Drake writes: Any PCI controller you have had good experience with? I don't have any PCI test data. How any other PCI-X/PCI-e controller that you have had good results? http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
Chris Ruprecht wrote: Joshua, did you try to run the 345 on an IBM ServeRAID 6i? No the only controllers I had at the time were the 2120 and the LSI on board that is limited to RAID 1. I put the drives on the LSI in JBOD and used Linux software raid. The key identifier for me was using a s

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Chris Ruprecht
Joshua, did you try to run the 345 on an IBM ServeRAID 6i? I have one in mine, but I never actually ran any speed test. Do you have any benchmarks that I could run and compare? best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre On May 12, 2008, at 22:11, Josh

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Francisco Reyes
Joshua D. Drake writes: Most likely you have a scsi onboard as well I am guessing. Will check. shouldn't bother with the 2120. My tests show it is a horrible controller for random writes. Thanks for the feedback.. Comparing software raid on an LSI onboard for an IBM 345 versus a 2120s u

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
On Mon, 12 May 2008 22:04:03 -0400 Francisco Reyes <[EMAIL PROTECTED]> wrote: > Inheritted a number of servers and I am starting to look into the > hardware. > > So far what I know from a few of the servers > Redhat servers. > 15K rpm disks, 12GB to 32GB of RAM. > Adaptec 2120 SCSI controller (64

[PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Francisco Reyes
Inheritted a number of servers and I am starting to look into the hardware. So far what I know from a few of the servers Redhat servers. 15K rpm disks, 12GB to 32GB of RAM. Adaptec 2120 SCSI controller (64MB of cache). The servers have mostly have 12 drives in RAID 10. We are going to redo one m

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on aNAS

2003-10-23 Thread scott.marlowe
On Thu, 23 Oct 2003, Alexander Priem wrote: > I have been searching (www.lsil.com) for this megaraid_2 driver you > mentioned. > > What kind of MegaRaid card does the Perc4/Di match? Elite1600? Elite1650? > > I picked Elite1600 and the latest driver I found was version 2.05.00. Is > this one OK

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on aNAS device ?

2003-10-23 Thread Alexander Priem
I have been searching (www.lsil.com) for this megaraid_2 driver you mentioned. What kind of MegaRaid card does the Perc4/Di match? Elite1600? Elite1650? I picked Elite1600 and the latest driver I found was version 2.05.00. Is this one OK for RedHat 9? The README file present only mentions RedHat8

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on a

2003-10-22 Thread Will LaShell
Heya On Wed, 2003-10-22 at 01:13, Alexander Priem wrote: > So I guess the PERC4/Di RAID controller is pretty good. It seems that > RedHat9 supports it out-of-the-box (driver 1.18f), but I gather from the > sites mentioned before that upgrading this driver to 1.18i would be > better... Actually up

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on a NAS device ?

2003-10-22 Thread Alexander Priem
So I guess the PERC4/Di RAID controller is pretty good. It seems that RedHat9 supports it out-of-the-box (driver 1.18f), but I gather from the sites mentioned before that upgrading this driver to 1.18i would be better... ---(end of broadcast)--- TIP

Re: [PERFORM] RAID controllers etc... was: PostgreSQL data on a NAS device ?

2003-10-21 Thread Will LaShell
On Tue, 2003-10-21 at 13:36, scott.marlowe wrote: > On 21 Oct 2003, Will LaShell wrote: > > > On Tue, 2003-10-21 at 08:40, scott.marlowe wrote: > > > > > So that brings up my question, which is better, the Perc4 or Perc3 > > > controllers, and what's the difference between them? I find Dell's

[PERFORM] RAID controllers etc... was: PostgreSQL data on a NAS device ?

2003-10-21 Thread scott.marlowe
On 21 Oct 2003, Will LaShell wrote: > On Tue, 2003-10-21 at 08:40, scott.marlowe wrote: > > > So that brings up my question, which is better, the Perc4 or Perc3 > > controllers, and what's the difference between them? I find Dell's > > tendency to hide other people's hardware behind their own