Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F235F650EA2 for ; Wed, 25 Jun 2008 07:57:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07276-01 for ; Wed, 25 Jun 2008 07:56:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.154]) by postgresql.org (Postfix) with ESMTP id 77371650E99 for ; Wed, 25 Jun 2008 07:57:01 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so1575939fgg.23 for ; Wed, 25 Jun 2008 03:56:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; 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; bh=vPxoGvB1WELDMjFuXZPh1QCOTgZFvfYJKprDP9sOmeg=; b=HKlD7jTMSkqQjOGm7K4HWyQgF9UUaHlyM+WIOnYkKQR0Rugwpkb1g+fbyHnCYDZ94u ECN2ZPWHIoRcPXaoSTofHZVxMUsJziXmpWZmdPlDpQPs05Kz7WOYmfstJNQuIIK2GvDj VoN7UtuUE3zY4bK4V0LQeg5dodaALVgYRg1xw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Ay0X7TqDUUAWd9hzfLQXN3075xlK1RvtAgek6Aq3u662HJs2SvXsSRmJGAYSRdRRPs vLMQavUVR9Qk1qN5SiDDIKK91PFDzfldmhT/qAzl+WIL5uLUnvkc5/Sj8PFF3o898fa5 ErrcRFdExg/1Wun+SRXDaK6x8t+UXKrIQegvo= Received: by 10.86.33.19 with SMTP id g19mr10280780fgg.4.1214391419662; Wed, 25 Jun 2008 03:56:59 -0700 (PDT) Received: by 10.86.79.5 with HTTP; Wed, 25 Jun 2008 03:56:59 -0700 (PDT) Message-ID: Date: Wed, 25 Jun 2008 12:56:59 +0200 From: "Claus Guttesen" To: Henrik Subject: Re: Hardware suggestions for high performance 8.3 Cc: pgsql-performance@postgresql.org In-Reply-To: <2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/126 X-Sequence-Number: 30476 > We have a database with lots of small simultaneous writes and reads > (millions every day) and are looking at buying a good hardware for this. > > What are your suggestions. What we are currently looking at is. > > Dual Quad Core Intel > 8 - 12 GB RAM > > 10 disks total. > > 4 x 146 GB SAS disk in RAID 1+0 for database > 6 x 750 GB SATA disks in RAID 1+0 or RAID 5 for OS and transactions logs. > > Good RAID controller with lots of memory and BBU. I have very positive experiences with HP's DL360 and DL380. The latter slightly more expandable (2U vs. 1U). I have used the internal p400i-controller with 512 MB cache on the DL380 and bought an external p800-controller (512 MB cache as well) and a MSA-70-cabinet. I've have 11 disks in raid-6 (one hotspare). I don't see any reason to mix sas- and sata-disks with different sizes. I'd go for sas-disks, smaller and faster, less power and heat. Raid 1+0 or raid-6 does not seem to make much of a difference today as it used to if you have more than 6-7 disks. The DL380 is a 4-way woodcrest at 3 GHz and 16 GB ram and the DL360 is a two-way woodcrest at 2.66 GHz with 16 GB. My personal preference is FreeBSD and the DL3x0-servers all run without problems on this platform. But choose your OS depending on what you're most comfortable with. And choose hardware according to what your OS supports. Areca-controllers may also be worth looking into but I haven't tried these myself. Our largest table has 85 mill. entries. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare