X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55073D1B1B7 for ; Wed, 16 Jun 2004 17:49:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51006-01 for ; Wed, 16 Jun 2004 20:49:23 +0000 (GMT) Received: from relay.snowman.net (snowman.net [66.93.83.236]) by svr1.postgresql.org (Postfix) with ESMTP id B6C10D1B18C for ; Wed, 16 Jun 2004 17:49:19 -0300 (ADT) Received: from ns.snowman.net (ns.snowman.net [10.10.0.2]) by relay.snowman.net (8.12.11/8.12.11/Debian-5) with ESMTP id i5GKnCTr016304; Wed, 16 Jun 2004 16:49:12 -0400 Received: from ns.snowman.net (localhost [127.0.0.1]) by ns.snowman.net (8.12.11/8.12.10/Debian-5) with ESMTP id i5GKnIC9029875; Wed, 16 Jun 2004 16:49:18 -0400 Received: (from sfrost@localhost) by ns.snowman.net (8.12.11/8.12.10/Debian-5) id i5GKnIjR029873; Wed, 16 Jun 2004 16:49:18 -0400 Date: Wed, 16 Jun 2004 16:49:18 -0400 From: Stephen Frost To: Scott Marlowe Cc: Bill , pgsql-performance@postgresql.org Subject: Re: Basic Postgresql Performance Question Message-ID: <20040616204917.GC11196@ns.snowman.net> Mail-Followup-To: Scott Marlowe , Bill , pgsql-performance@postgresql.org References: <1087413327.3207.9.camel@mathlab09.uchicago.edu> <1087417125.1582.47.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="A+dGWgJqhC09RTtY" Content-Disposition: inline In-Reply-To: <1087417125.1582.47.camel@localhost.localdomain> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 16:47:09 up 137 days, 15:52, 6 users, load average: 0.17, 0.25, 0.26 User-Agent: Mutt/1.5.5.1+cvs20040105i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/165 X-Sequence-Number: 7223 --A+dGWgJqhC09RTtY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Scott Marlowe (smarlowe@qwest.net) wrote: > On Wed, 2004-06-16 at 13:15, Bill wrote: > > 2. It is advantageous to buy AMD 64 rather than the Pentium IV? >=20 > Yes and no. If having more than 2 gigs of ram is important, 64 bit > architecures run faster than 32 bit, where having over 2 gigs usually > results in a slow down due to the memory switching they use. This is truer on more traditional 64bit platforms than on amd64 which has more differences than just the ability to handle 64bit size things. amd64 also gives you access to more registers than were on the register-starved i386 platforms which increases the speed for most applications where it usually wouldn't when recompiled for 64bit. Stephen --A+dGWgJqhC09RTtY Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0LJNrzgMPqB3kigRAqj1AKCAuNVeEW1XBu+RIbCCraTqSsVorgCdE48V U6+Yn7GgHV28Zs7X6CMq8A0= =YR0r -----END PGP SIGNATURE----- --A+dGWgJqhC09RTtY--