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 A2BACD1B511; Thu, 9 Oct 2003 14:27:47 +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 37222-02; Thu, 9 Oct 2003 11:27:04 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 66926D1B4E5; Thu, 9 Oct 2003 11:27:00 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1A7bkv-0003E5-00; Thu, 09 Oct 2003 10:27:05 -0400 Received: by dba2 (Postfix, from userid 1019) id 0F6F8CD6B; Thu, 9 Oct 2003 10:27:05 -0400 (EDT) Date: Thu, 9 Oct 2003 10:27:05 -0400 From: Andrew Sullivan To: PostgreSQL Performance , PostgreSQL-development Subject: Re: [HACKERS] Sun performance - Major discovery! Message-ID: <20031009142704.GD14048@libertyrms.info> Mail-Followup-To: Andrew Sullivan , PostgreSQL Performance , PostgreSQL-development References: <200310081831.h98IVT919657@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200310081831.h98IVT919657@candle.pha.pa.us> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/271 X-Sequence-Number: 4019 On Wed, Oct 08, 2003 at 02:31:29PM -0400, Bruce Momjian wrote: > Well, this is really embarassing. I can't imagine why we would not set > at least -O on all platforms. Looking at the template files, I see > these have no optimization set: I think gcc _used_ to generate bad code on SPARC if you set any optimisation. We tested it on Sol7 with gcc 2.95 more than a year ago, and tried various settings. -O2 worked, but other items were really bad. Some of them would pass regression but cause strange behaviour, random coredumps, &c. A little digging demonstrated that anything beyond -O2 just didn't work for gcc at the time. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110