X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 594DF3A5FA6 for ; Mon, 6 Dec 2004 17:29:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11547-08 for ; Mon, 6 Dec 2004 17:29:45 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 2F6AF3A5F9D for ; Mon, 6 Dec 2004 17:29:46 +0000 (GMT) Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6751848 for pgsql-performance@postgresql.org; Mon, 06 Dec 2004 09:31:18 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Processor optimization compile options? Date: Mon, 6 Dec 2004 09:26:34 -0800 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <200412060926.34124.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/116 X-Sequence-Number: 9491 Folks, I'm wondering if people have had success with 7.4 and 8.0 using specific compile optimizations not provided by the default PG install. Since -O2 and others have been built into config, I've not been doing much myself. What are other people's experiences in this area? Do you have any stats to back it up? -- Josh Berkus Aglio Database Solutions San Francisco