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 AA3DDD1B584 for ; Thu, 9 Oct 2003 19:26:52 +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 07373-03 for ; Thu, 9 Oct 2003 16:26:08 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id DA15AD1B58D for ; Thu, 9 Oct 2003 16:20:57 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h99JKvQj025547 for ; Thu, 9 Oct 2003 19:20:57 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h99JA05E023992 for pgsql-performance@postgresql.org; Thu, 9 Oct 2003 19:10:00 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Sun performance - Major discovery! Date: Thu, 09 Oct 2003 14:12:30 -0400 Organization: Hub.Org Networking Services Lines: 17 Message-ID: <60znga5lgx.fsf@dev6.int.libertyrms.info> References: <200310091708.h99H8fY07153@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:zYe+1TgI8wS+5qB9MUl8rUqWAgA= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/300 X-Sequence-Number: 4048 pgman@candle.pha.pa.us (Bruce Momjian) writes: > 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. You might also mention something like the following: If you are compiling using GCC, you will quite likely want to add in the "-O2" compile flag. -- let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];; Christopher Browne (416) 646 3304 x124 (land)