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 045E3D1B52A for ; Thu, 9 Oct 2003 16:27:15 +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 66232-06 for ; Thu, 9 Oct 2003 13:26:26 -0300 (ADT) Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by svr1.postgresql.org (Postfix) with ESMTP id 81A82D1B4EA for ; Thu, 9 Oct 2003 13:25:28 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by localhost.is.rice.edu (Postfix) with ESMTP id D62544193E; Thu, 9 Oct 2003 11:25:27 -0500 (CDT) Received: from is.rice.edu ([127.0.0.1]) by localhost (it.is.rice.edu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14525-08; Thu, 9 Oct 2003 11:25:25 -0500 (CDT) Received: by is.rice.edu (Postfix, from userid 18612) id 9E1FE418CB; Thu, 9 Oct 2003 11:25:25 -0500 (CDT) Date: Thu, 9 Oct 2003 11:25:25 -0500 From: Kenneth Marshall To: Jeff Cc: Bruce Momjian , Neil Conway , "pgsql-performance@postgresql.org" Subject: Re: Sun performance - Major discovery! Message-ID: <20031009162525.GB10888@it.is.rice.edu> References: <200310091551.h99FpUa07732@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.25i X-Virus-Scanned: by amavis-20030314-p2 at is.rice.edu X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/450 X-Sequence-Number: 4198 Jeff, My first concern with the -fast option is that it makes an executable that is specific for the platform on which the compilation is run unless other flags are given. My second concern is the effect it has on IEEE floating point behavior w.r.t. rounding, error handling, .... And my third concern is that if you use -fast, all other code must be compiled and linked with the -fast option for correct operation, this includes any functional languages such as perl, python, R,... That is a pretty big requirement for a default compilation flag. Ken Marshall On Thu, Oct 09, 2003 at 12:07:20PM -0400, Jeff wrote: > On Thu, 9 Oct 2003, Bruce Momjian wrote: > > > > 52 seconds to 19-20 seconds > > > > Wow, that's dramatic. Do you want to propose some flags for non-gcc > > Solaris? Is -fast the only one? Is there one that suppresses those > > warnings or are they OK? > > > > Well. As I said, I didn't see an obvious way to hide those warnings. > I'd love to make those warnings go away. That is why I suggested perhaps > printing a message to ensure the user knows that warnings may be printed > when using sunsoft. > > -fast should be all you need - it picks the "best settings" to use for the > platform that is doing the compile. > > > -- > Jeff Trout > http://www.jefftrout.com/ > http://www.stuarthamm.net/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings