Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1A0C6475AD7 for ; Sat, 18 Jan 2003 01:55:09 -0500 (EST) Received: from lakemtao02.cox.net (lakemtao02.cox.net [68.1.17.243]) by postgresql.org (Postfix) with ESMTP id 824EA474E53 for ; Sat, 18 Jan 2003 01:55:08 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao02.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030118065508.GYLM6744.lakemtao02.cox.net@[192.168.1.1]> for ; Sat, 18 Jan 2003 01:55:08 -0500 Subject: Re: x86-64 and PostgreSQL From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <22328.1042872275@sss.pgh.pa.us> References: <1042867764.889.181.camel@haggis> <22328.1042872275@sss.pgh.pa.us> Content-Type: text/plain Organization: Message-Id: <1042872864.7792.43.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 18 Jan 2003 00:55:04 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/194 X-Sequence-Number: 841 On Sat, 2003-01-18 at 00:44, Tom Lane wrote: > 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. That's kinda what I expected. The ability to /relatively/ inexpensively get a box chock full of RAM couldn't hurt, though... Putting a 12GB database on a box with 8GB RAM has to make it run pretty fast. (As long as you aren't joining mismatched types!!!) -- +------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Basically, I got on the plane with a bomb. Basically, I | | tried to ignite it. Basically, yeah, I intended to damage | | the plane." | | RICHARD REID, who tried to blow up American Airlines | | Flight 63 | +------------------------------------------------------------+