X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 155E5D1B51E for ; Tue, 11 Nov 2003 23:33:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52424-08 for ; Tue, 11 Nov 2003 19:33:05 -0400 (AST) Received: from corp1.affinitysolutions.com (corp1.affinitysolutions.com [216.52.88.186]) by svr1.postgresql.org (Postfix) with ESMTP id 026ADD1B50C for ; Tue, 11 Nov 2003 19:33:03 -0400 (AST) Received: from tuxsrva.afsnyc-nt1.affinitysolutions.com (unknown [216.220.102.122]) by corp1.affinitysolutions.com (Postfix) with ESMTP id 06B9B11F705 for ; Tue, 11 Nov 2003 18:32:49 -0500 (EST) Subject: Value of Quad vs. Dual Processor machine From: Chris Field Reply-To: cfield@affinitysolutions.com To: pgsql-performance@postgresql.org Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Pp9U7L6ZAviF2yFBgYtQ" Organization: Affinity Solutions Message-Id: <1068593567.2063.8.camel@tuxsrva> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Tue, 11 Nov 2003 18:32:47 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/50 X-Sequence-Number: 4610 --=-Pp9U7L6ZAviF2yFBgYtQ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable We are getting ready to spec out a new machine and are wondering about the wisdom of buying a quad versus a dual processor machine. Seing as how postgres in not a threaded application, and this server will only be used for log/transaction analysis (it will only ever have a few large queries running). Is there any performance to be gained, and if so is it worth the large cost? Any thoughts/experience are much appreciated... --=20 Chris Field cfield@affinitysolutions.com Affinity Solutions Inc. 386 Park Avenue South Suite 1209 New York, NY 10016 (212) 685-8748 ext. 32 --=-Pp9U7L6ZAviF2yFBgYtQ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQA/sXGfkTUAUyBR2GYRAthQAJ9MUbHD426ykBbMWtbKc2udiPKXbwCfVDFY LHQzFgVUwTNDE8PQxHwSgfQ= =Z6sz -----END PGP SIGNATURE----- --=-Pp9U7L6ZAviF2yFBgYtQ--