Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3E9C7632B23 for ; Thu, 10 Jun 2010 11:11:24 -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 95208-06 for ; Thu, 10 Jun 2010 14:11:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id B6F026321AC for ; Thu, 10 Jun 2010 11:11:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o5AEAu33015384; Thu, 10 Jun 2010 10:10:56 -0400 (EDT) To: Max Williams cc: "pgsql-performance@postgresql.org" Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? In-reply-to: <0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local> References: <0357196CB603794BB76F4F6B373F27330506EACE45@SERVER.ddnglobal.local> <1276158598.5764.22.camel@hp-laptop2.gunduz.org> <0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local> Comments: In-reply-to Max Williams message dated "Thu, 10 Jun 2010 11:19:41 +0100" Date: Thu, 10 Jun 2010 10:10:56 -0400 Message-ID: <15383.1276179056@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.916 tagged_above=-10 required=5 tests=BAYES_00=-1.9, PLING_QUERY=0.994, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/159 X-Sequence-Number: 39015 Max Williams writes: > How do I tell if it was built with debugging options? Run pg_config --configure and see if --enable-cassert is mentioned. regards, tom lane