Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 96676633818 for ; Wed, 11 Aug 2010 12:18:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 78158-01 for ; Wed, 11 Aug 2010 15:17:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from joeconway.com (wsip-72-214-29-243.sd.sd.cox.net [72.214.29.243]) by mail.postgresql.org (Postfix) with ESMTP id 1255F632F4D for ; Wed, 11 Aug 2010 12:17:52 -0300 (ADT) Received: from [206.173.27.2] (account jconway HELO jec-macbook-pro.local) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 9997362 for pgsql-performance@postgresql.org; Wed, 11 Aug 2010 08:17:51 -0700 Message-ID: <4C62BF17.6090300@joeconway.com> Date: Wed, 11 Aug 2010 08:17:43 -0700 From: Joseph Conway User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1.11) Gecko/20100711 Lightning/1.0b1 Thunderbird/3.0.6 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: 32 vs 64 bit build on Solaris Sparc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.483 tagged_above=-10 required=5 tests=BAYES_05=-0.5, RDNS_DYNAMIC=0.982, TO_NO_BRKTS_DYNIP=0.001 X-Spam-Level: X-Archive-Number: 201008/127 X-Sequence-Number: 39970 With a 16 CPU, 32 GB Solaris Sparc server, is there any conceivable reason to use a 32 bit build rather than a 64 bit build? Apparently the Sun PostgreSQL package includes a README that indicates you might want to think twice about using 64 bit because it is slower -- this seems like outdated advice, but I was looking for confirmation one way or the other. Also semi-related question: when building from source, using gcc, enabling debug (but *not* assert) is normally not much of a performance hit. Is the same true if you build with the Sun CC? Thanks in advance for any thoughts/experiences. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support