Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0480B475ED1 for ; Sat, 18 Jan 2003 11:39:31 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 71918475AD7 for ; Sat, 18 Jan 2003 11:39:30 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18Zw0N-0006ZM-00 for ; Sat, 18 Jan 2003 11:39:35 -0500 Date: Sat, 18 Jan 2003 11:39:35 -0500 From: Andrew Sullivan To: PgSQL Performance ML Subject: Re: x86-64 and PostgreSQL Message-ID: <20030118113935.C23790@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , PgSQL Performance ML References: <1042867764.889.181.camel@haggis> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1042867764.889.181.camel@haggis>; from ron.l.johnson@cox.net on Fri, Jan 17, 2003 at 11:29:25PM -0600 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/197 X-Sequence-Number: 844 On Fri, Jan 17, 2003 at 11:29:25PM -0600, Ron Johnson wrote: > Hi, > > Will there be any advantages to running Pg on a 64-bit CPU rather > than 32-bit? In my experience, not really. We use SPARCs under Solaris 7 and, now, 8. We haven't found any terribly obvious advantages with the system compiled as a 64 bit app, but we _did_ find problems with the 64 bit libraries combined with gcc. As a result of that and pressures to get working on some other things, we stopped testing Postgres as a 64 bit app on Solaris. We haven't done any work on Solaris 8 with it, and that system is a little more mature in the 64-bit-support department, so when I have a chance do to more investigation, I will. > Also, would int8 then become a more "natural" default integer, rather > than the int4 that all of us millions of i386, PPC & Sparc users use? I think the problem with int8s in a lot of cases has more to do with typer coercion. So at least in systems < 7.4, I'm not sure you'll see a big win, unless you make sure to cast everything correctly. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110