Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 6CEF7632978
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 11 Jun 2010 13:50:17 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 16382-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 11 Jun 2010 16:50:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 93137632731
	for <pgsql-performance@postgresql.org>;
	Fri, 11 Jun 2010 13:50:08 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <gcdpp-pgsql-performance@m.gmane.org>)
	id 1ON7Qh-0001YW-Qz
	for pgsql-performance@postgresql.org; Fri, 11 Jun 2010 18:50:03 +0200
Received: from wsip-72-215-173-127.sb.sd.cox.net ([72.215.173.127])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Fri, 11 Jun 2010 18:50:03 +0200
Received: from jreeve by wsip-72-215-173-127.sb.sd.cox.net with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Fri, 11 Jun 2010 18:50:03 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-performance@postgresql.org
connect(): No such file or directory
From: John Reeve <jreeve@pelagodesign.com>
Subject: Re: Large (almost 50%!) performance drop =?utf-8?b?YWZ0ZXIJ?=
	upgrading to 8.4.4?
Date: Fri, 11 Jun 2010 16:34:30 +0000 (UTC)
Lines: 32
Message-ID: <loom.20100611T183107-148@post.gmane.org>
References: 
 <0357196CB603794BB76F4F6B373F27330506EACE45@SERVER.ddnglobal.local>
	<AANLkTilfB0IIBqN8MG_vCPDba0R2NxcXgjIM7Axj61wM@mail.gmail.com>
	<1276158598.5764.22.camel@hp-laptop2.gunduz.org>
	<0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local>
	<15383.1276179056@sss.pgh.pa.us>
	<0357196CB603794BB76F4F6B373F27330506EACE55@SERVER.ddnglobal.local>
	<4C10BB59020000250003214A@gw.wicourts.gov>
	<0357196CB603794BB76F4F6B373F27330506EACE56@SERVER.ddnglobal.local>
	<4C1147F0.2090607@2ndquadrant.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: sea.gmane.org
User-Agent: Loom/3.14 (http://gmane.org/)
X-Loom-IP: 72.215.173.127 (Mozilla/5.0 (Windows; U; Windows NT 6.1;
	en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.55
	Safari/533.4)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.983 tagged_above=-10 required=5
	tests=BAYES_40=-0.001, PLING_QUERY=0.994, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201006/213
X-Sequence-Number: 39069

Greg Smith <greg <at> 2ndquadrant.com> writes:

> 
> Max Williams wrote:
> > Can I just turn this off on 8.4.4 or is it a compile time option
> 
> You can update your postgresql.conf to include:
> 
> debug_assertions = false
> 
> And restart the server.  This will buy you back *some* of the 
> performance loss but not all of it.  Will have to wait for corrected 
> packaged to make the issue completely go away.
> 


Ah! I am so thankful I found this thread. We've been having the same issues 
described here. And when I do a SHOW debug_assertions I get:


postgres=# show debug_assertions;
 debug_assertions
------------------
 on
(1 row)


Can you let us know when the corrected packages have become available?

Regards,
John