pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: John Reeve <jreeve@pelagodesign.com>
To: pgsql-performance@postgresql.org
Subject: Re: Large (almost 50%!) performance drop after	 upgrading to 8.4.4?
Date: Fri, 11 Jun 2010 16:34:30 +0000 (UTC)
Message-ID: <loom.20100611T183107-148@post.gmane.org> (raw)
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>

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





view thread (19+ messages)  latest in thread

Message-ID: <loom.20100611T183107-148@post.gmane.org>
Permalink:  ../loom.20100611T183107-148@post.gmane.org/
Also on:    postgresql.org/message-id/loom.20100611T183107-148@post.gmane.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jreeve@pelagodesign.com
  Subject: Re: Large (almost 50%!) performance drop after	 upgrading to 8.4.4?
  In-Reply-To: <loom.20100611T183107-148@post.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox