Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BC22D475AD7 for ; Sat, 18 Jan 2003 00:29:47 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 072814758E1 for ; Sat, 18 Jan 2003 00:29:47 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030118052952.GMJC8666.lakemtao03.cox.net@[192.168.1.1]> for ; Sat, 18 Jan 2003 00:29:52 -0500 Subject: x86-64 and PostgreSQL From: Ron Johnson To: PgSQL Performance ML Content-Type: text/plain Organization: Message-Id: <1042867764.889.181.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 17 Jan 2003 23:29:25 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/193 X-Sequence-Number: 840 Hi, Will there be any advantages to running Pg on a 64-bit CPU rather than 32-bit? The recent discussions in the "7.3.1 New install, large queries are slow" thread make me think not, since Pg says that the OS can manage buffers better: Yeah, but isn't that theory a hangover from pre-Unix operating systems? In all modern Unixen, you can expect the kernel to make use of any spare RAM for disk buffer cache --- and that behavior makes it pointless for Postgres to try to do large amounts of its own buffering. Having a page in our own buffer instead of kernel buffer saves a context swap to access the page, but it doesn't save I/O, so the benefit is a lot less than you might think. I think there's seriously diminishing returns in pushing shared_buffers beyond a few thousand, and once you get to the point where it distorts the kernel's ability to manage memory for processes, you're really shooting yourself in the foot. 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? Thanks, Ron -- +------------------------------------------------------------+ | 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 | +------------------------------------------------------------+