X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0013DD1C4D5 for ; Thu, 31 Jul 2003 05:45:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 25954-01 for ; Thu, 31 Jul 2003 02:44:20 -0300 (ADT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id AC2E5D1C4D0 for ; Thu, 31 Jul 2003 02:45:21 -0300 (ADT) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao04.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030731054524.NYJI13930.lakemtao04.cox.net@[192.168.1.1]> for ; Thu, 31 Jul 2003 01:45:24 -0400 Subject: Targeted CPU compilations From: Ron Johnson To: PgSQL Performance ML Content-Type: text/plain Message-Id: <1059630316.7508.368.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 31 Jul 2003 00:45:17 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/495 X-Sequence-Number: 2788 Hi, Has anyone done any benchmarks to see if PG compiled for the target CPU (Athlon XP, P4 Xeon, Pentium III, etc) is significantly more efficient than when compiled for the i386? This should also apply to Sparc, Alpha, etc. Yes, more RAM and faster disks are extremely important, but when the fast disks have sucked the commonly shared data into all that RAM, the RAM cache will be exercise heavily, and that means lots of CPU. Business logic embedded in SQL and stored procedures, and CRC (or MD5) calculations would also be sped up. -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+