Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 252114763C3 for ; Sat, 18 Jan 2003 01:44:38 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5859C47636B for ; Sat, 18 Jan 2003 01:44:37 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0I6iZ5u022329; Sat, 18 Jan 2003 01:44:36 -0500 (EST) To: Ron Johnson Cc: PgSQL Performance ML Subject: Re: x86-64 and PostgreSQL In-reply-to: <1042867764.889.181.camel@haggis> References: <1042867764.889.181.camel@haggis> Comments: In-reply-to Ron Johnson message dated "17 Jan 2003 23:29:25 -0600" Date: Sat, 18 Jan 2003 01:44:35 -0500 Message-ID: <22328.1042872275@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/195 X-Sequence-Number: 842 Ron Johnson writes: > Will there be any advantages to running Pg on a 64-bit CPU rather > than 32-bit? Not so's you'd notice. PG is designed to be cross-platform, and at the moment that means 32-bit-centric. There's been occasional talk of improving the performance of float8 and int8 types on 64-bit machines, but so far it's only idle talk; and in any case I think that performance improvements for those two datatypes wouldn't have much effect for average applications. regards, tom lane