Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7BC0A9F96AF for ; Wed, 12 Sep 2007 04:17:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30722-02 for ; Wed, 12 Sep 2007 04:17:26 -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 2FC019F96A2 for ; Wed, 12 Sep 2007 04:17:24 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so93977nfh for ; Wed, 12 Sep 2007 00:17:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; 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; bh=9yrlxJtBWLnDtPEkv0rsSH7xqTEWchMJ97mRDfJTMm4=; b=nO/fKlo3TRrE1N5p24ueqPbr46RwqcqFan7trneiqnnswb/bQGX8Qe1vC/5HCIEADZIYVXlU4aFu+OUZ2UnyGt/OnmgjkMFhkUqTWNhYcgtOG4MhECo4rukmkuAjwu0FXpG0nSeMeO7VtB4iNrA3Ia21zYcMm/ZY5q5E6ckHbgY= 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=OYJGIwwVDERGi8xU8oGHET0b0tF8chVholOYCilFQ27UVrzkII8fvVUhMwSoxgfT65m7Sx9PMzTKs+97jm3mQHaxsgUNc6+0m68dVxDJBSGX1m1oGA2PeIVb6Zg1kiROc4fywYocctvJ7CzkNLLIoZYnPvxry9TEHeVbveYyhGw= Received: by 10.78.185.15 with SMTP id i15mr2997909huf.1189581443230; Wed, 12 Sep 2007 00:17:23 -0700 (PDT) Received: by 10.78.159.13 with HTTP; Wed, 12 Sep 2007 00:17:23 -0700 (PDT) Message-ID: Date: Wed, 12 Sep 2007 09:17:23 +0200 From: "Claus Guttesen" To: "Willo van der Merwe" Subject: Re: Hardware spec Cc: Decibel! , "Richard Huxton" , pgsql-performance@postgresql.org In-Reply-To: <46E78EBE.8050501@mirasol.co.za> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46DFA43C.2030201@mirasol.co.za> <46DFB79E.9040407@archonet.com> <46DFC7D6.2080803@mirasol.co.za> <20070911203554.GZ38801@decibel.org> <46E78EBE.8050501@mirasol.co.za> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/220 X-Sequence-Number: 26765 > > Get yourself the ability to benchmark your application. This is > > invaluable^W a requirement for any kind of performance tuning. > > > I'm pretty happy with the performance of the database at this stage. > Correct me if I'm wrong, but AFAIK a load of 3.5 on a quad is not > overloading it. It also seem to scale well, so if application's demand > increases I see a minimal increase in database server load. > > I was just looking for some pointers as to where to go to ITO hardware > for the future, as I can now spec a new machine. I mean is it really > worth while going for one of those RAID controllers with the battery > backed cache, for instance. If so, are there any specific ones to look > out for? Which is better RAID 5, a large RAID 10 or smaller RAID 10's? > Should I bother with RAID at all? These issues have been covered before. You may want to search the archives and get the relevant pointers. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare