Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2F4879F9C4A for ; Tue, 11 Sep 2007 17:36:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 19441-05 for ; Tue, 11 Sep 2007 17:35:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A12679F9D17 for ; Tue, 11 Sep 2007 17:35:59 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 639E8564D2; Tue, 11 Sep 2007 20:35:58 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 11 Sep 2007 15:35:55 -0500 Date: Tue, 11 Sep 2007 15:35:55 -0500 From: Decibel! To: Willo van der Merwe Cc: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Hardware spec Message-ID: <20070911203554.GZ38801@decibel.org> References: <46DFA43C.2030201@mirasol.co.za> <46DFB79E.9040407@archonet.com> <46DFC7D6.2080803@mirasol.co.za> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="9rrfksQwzphoq1W+" Content-Disposition: inline In-Reply-To: <46DFC7D6.2080803@mirasol.co.za> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070911:willo@mirasol.co.za::yTBAunsTCuM6YERq:000000000000000000 0000000000000000000000001eK1 X-Hashcash: 1:20:070911:dev@archonet.com::6gHjGf5Raek9XX+Z:06pYd X-Hashcash: 1:20:070911:pgsql-performance@postgresql.org::DEfzpT6Nu2ShLnan:00000 0000000000000000000000006RkX X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/196 X-Sequence-Number: 26741 --9rrfksQwzphoq1W+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Sep 06, 2007 at 11:26:46AM +0200, Willo van der Merwe wrote: > Richard Huxton wrote: > >Willo van der Merwe wrote: > >>Hi guys, > >> > >>I'm have the rare opportunity to spec the hardware for a new database > >>server. It's going to replace an older one, driving a social networking > >>web application. The current server (a quad opteron with 4Gb of RAM and > >>80Gb fast SCSI RAID10) is coping with an average load of ranging between > >>1.5 and 3.5. > >> > >>The new machine spec I have so far: > >What's the limiting factor on your current machine - disk, memory, cpup? > I'm a bit embarrassed to admit that I'm not sure. The reason we're=20 > changing machines is that we might be changing ISPs and we're renting /= =20 > leasing the machines from the ISP. Get yourself the ability to benchmark your application. This is invaluable^W a requirement for any kind of performance tuning. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --9rrfksQwzphoq1W+ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFG5vwqdO30qud8SkgRAtekAJ4tqwtP1sJXdxXIzCE8aP6brs2ffwCff2FB dvup+7zMXlp+OzJgCadZ988= =b+F1 -----END PGP SIGNATURE----- --9rrfksQwzphoq1W+--