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 A0406D1B4E9 for ; Thu, 9 Oct 2003 17:09:36 +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 70918-07 for ; Thu, 9 Oct 2003 14:08:50 -0300 (ADT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 67B8FD1B531 for ; Thu, 9 Oct 2003 14:08:48 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id h99H8fY07153; Thu, 9 Oct 2003 13:08:41 -0400 (EDT) From: Bruce Momjian Message-Id: <200310091708.h99H8fY07153@candle.pha.pa.us> Subject: Re: Sun performance - Major discovery! In-Reply-To: To: Jeff Date: Thu, 9 Oct 2003 13:08:41 -0400 (EDT) Cc: Kenneth Marshall , Neil Conway , "pgsql-performance@postgresql.org" X-Mailer: ELM [version 2.4ME+ PL106 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/284 X-Sequence-Number: 4032 Jeff wrote: > On Thu, 9 Oct 2003, Kenneth Marshall wrote: > > > 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 > > > > So you think we should leave PG alone and let it run horrifically slowly? > Do you have a better idea of how to do this? > > And do you have evidence apps compiled with -fast linked to non -fast > (or gcc compiled) have problems? I have updated the Solaris FAQ: 5) How can I compile for optimum performance? Try using the "-fast" compile flag. The binaries might not be portable to other Solaris systems, and you might need to compile everything that links to PostgreSQL with "-fast", but PostgreSQL will run significantly faster, 50% faster on some tests. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073