Re: [PERFORM] hardare config question

2006-05-01 Thread Erik Myllymaki
guess who just bought a 3ware BBU on ebay... Thanks for all the posts, consider me educated! (on the importance of BBU on RAID controllers, anyway) :) Scott Marlowe wrote: On Mon, 2006-05-01 at 13:22, Tom Arthurs wrote: UPS does not protect against the tech behind the rack unplugging the po

Re: [PERFORM] hardare config question

2006-05-01 Thread Scott Marlowe
On Mon, 2006-05-01 at 13:22, Tom Arthurs wrote: > UPS does not protect against the tech behind the rack unplugging the > power cable, or an accidental power cycle from exercising the wrong > switch. :) Both are probably more common causes of failure than a total > power outage. > > Erik Myllym

Re: [PERFORM] hardare config question

2006-05-01 Thread Luke Lonergan
Title: Re: [PERFORM] hardare config question We use the 3Ware BBUs and they’re very nice, they self monitor and let you know about their capacity if it’s a problem. - Luke On 5/1/06 11:43 AM, "Erik Myllymaki" <[EMAIL PROTECTED]> wrote: good points, thanks. Tom Arthurs wrote

Re: [PERFORM] hardare config question

2006-05-01 Thread Tom Arthurs
UPS does not protect against the tech behind the rack unplugging the power cable, or an accidental power cycle from exercising the wrong switch. :) Both are probably more common causes of failure than a total power outage. Erik Myllymaki wrote: I have been in discussion with 3ware support and

Re: [PERFORM] hardare config question

2006-05-01 Thread Erik Myllymaki
good points, thanks. Tom Arthurs wrote: UPS does not protect against the tech behind the rack unplugging the power cable, or an accidental power cycle from exercising the wrong switch. :) Both are probably more common causes of failure than a total power outage. Erik Myllymaki wrote: I have

Re: [PERFORM] hardare config question

2006-05-01 Thread Vivek Khera
On May 1, 2006, at 1:58 PM, Erik Myllymaki wrote: Of course now i am in a dangerous situation - using volatile write cache without a BBU. It should be against the law to make RAID cards with caches that are not battery backed. If I were to use a UPS to ensure a soft shutdown in the eve

Re: [PERFORM] hardare config question

2006-05-01 Thread Mark Lewis
A UPS will make it less likely that the system will reboot and destroy your database due to a power failure, but there are other causes for a system reboot. With a BBU, the only component that can fail and cause catastrophic data loss is the RAID itself. With a UPS, you are additionally vulnerabl

Re: [PERFORM] hardare config question

2006-05-01 Thread Erik Myllymaki
I have been in discussion with 3ware support and after adjusting some settings, the 3ware card in RAID 1 gets better performance than the single drive. I guess this had everything to do with the write (and maybe read?) cache. Of course now i am in a dangerous situation - using volatile write ca

Re: [PERFORM] hardare config question

2006-04-28 Thread Luke Lonergan
Title: Re: [PERFORM] hardare config question Erik, I think you have a mismatch in your Linux driver and firmware for your 3Ware card.  Download a matched Linux driver and firmware from www.3ware.com and your problems should disappear. - Luke On 4/28/06 8:37 AM, "Erik Myllymaki&quo

Re: [PERFORM] hardare config question

2006-04-28 Thread Ron Peacetree
rom: Mark Lewis <[EMAIL PROTECTED]> >Sent: Apr 28, 2006 1:47 PM >To: Vivek Khera <[EMAIL PROTECTED]> >Cc: Pgsql performance >Subject: Re: [PERFORM] hardare config question > >It's also possible that the single SATA drive you were testing (or the >controller it

Re: [PERFORM] hardare config question

2006-04-28 Thread Mark Lewis
It's also possible that the single SATA drive you were testing (or the controller it was attached to) is lying about fsync and performing write caching behind your back, whereas your new controller and drives are not. You'll find a lot more info on the archives of this list about it, but basically

Re: [PERFORM] hardare config question

2006-04-28 Thread Vivek Khera
On Apr 28, 2006, at 11:37 AM, Erik Myllymaki wrote: When I had this installed on a single SATA drive running from the PE1800's on-board SATA interface, this operation took anywhere from 65-80 seconds. With my new RAID card and drives, this operation took 272 seconds!? switch it to RAID10

[PERFORM] hardare config question

2006-04-28 Thread Erik Myllymaki
This is a question that I also posted on Dell hardware forums, and I realize it probably belongs there more than here. But I am thinking someone might have some anecdotal information that could help me and this post may help someone else down the road. My PowerEdge 1800 (dual 3ghz Xeon, 3GB ra