Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4714A9FA4B8 for ; Fri, 10 Aug 2007 07:53:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 92320-06 for ; Fri, 10 Aug 2007 07:53:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id F0EC09FC2FB for ; Fri, 10 Aug 2007 07:53:22 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so257648nfh for ; Fri, 10 Aug 2007 03:53:21 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bVrDXHzxGiyOPSFPlPfiWK283QPdK0AhSvKa2yWpWctXd0P5LPF8Tvj+cZZeym/QjbMM2ZAzRMsmawX8VYCNjtjWfedz4J4ObqSQv14cpBgo3UK7IRaJszHJtL6LSrCeWJb9/HJOBI9of5bbLYeKgUjsNruUKh2qHemGc2tN9E0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Gg7zT8RqH338kuEMXnS/C8O6l7VscUzNGcq8dcN1GrNH88DofOChfKLlj5yQqlaH4MLKA6ocutsC5G5SpY8s5gzxdt39NZaIF6uEAkilpLgbOEwC9z25VxZkhWeerg7yUjK6j1ud3XgP0pgzjvThSSCsmAz8dQdKpzuBRCe2t40= Received: by 10.78.149.15 with SMTP id w15mr1224188hud.1186743200828; Fri, 10 Aug 2007 03:53:20 -0700 (PDT) Received: by 10.78.18.9 with HTTP; Fri, 10 Aug 2007 03:53:20 -0700 (PDT) Message-ID: Date: Fri, 10 Aug 2007 16:23:20 +0530 From: "Merlin Moncure" To: Decibel! Subject: Re: Dell Hardware Recommendations Cc: "Joe Uhl" , pgsql-performance@postgresql.org In-Reply-To: <20070809220502.GE20424@nasby.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46BB6F3D.6090608@gmail.com> <20070809220502.GE20424@nasby.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/104 X-Sequence-Number: 26234 On 8/10/07, Decibel! wrote: > On Thu, Aug 09, 2007 at 05:50:10PM -0400, Merlin Moncure wrote: > > Raid 10 is usually better for databases but in my experience it's a > > roll of the dice. If you factor cost into the matrix a SAS raid 05 > > might outperform a SATA raid 10 because you are getting better storage > > utilization out of the drives (n - 2 vs. n / 2). Then again, you > > might not. > > It's going to depend heavily on the controller and the workload. > Theoretically, if most of your writes are to stripes that the controller > already has cached then you could actually out-perform RAID10. But > that's a really, really big IF, because if the strip isn't in cache you > have to read the entire thing in before you can do the write... and that > costs *a lot*. > > Also, a good RAID controller can spread reads out across both drives in > each mirror on a RAID10. Though, there is an argument for not doing > that... it makes it much less likely that both drives in a mirror will > fail close enough to each other that you'd lose that chunk of data. > > Speaking of failures, keep in mind that a normal RAID5 puts you only 2 > drive failures away from data loss, while with RAID10 you can > potentially lose half the array without losing any data. If you do RAID5 > with multiple parity copies that does change things; I'm not sure which > is better at that point (I suspect it matters how many drives are > involved). when making hardware recommendations I always suggest to buy two servers and rig PITR with warm standby. This allows to adjust the system a little bit for performance over fault tolerance. Regarding raid controllers, I've found performance to be quite variable as stated, especially with regards to RAID 5. I've also unfortunately found bonnie++ to not be very reflective of actual performance in high stress environments. We have a IBM DS4200 that bangs out some pretty impressive numbers with our app using sata while the bonnie++ numbers fairly suck. merlin