Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? - Mailing list pgsql-performance

From Max Williams
Subject Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date
Msg-id 0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local
Whole thread Raw
In response to Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
How do I tell if it was built with debugging options?


-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] 
Sent: 10 June 2010 09:30
To: Robert Haas
Cc: Max Williams; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

On Wed, 2010-06-09 at 21:51 -0400, Robert Haas wrote:
> On Wed, Jun 9, 2010 at 6:56 AM, Max Williams <Max.Williams@mflow.com>
> wrote:
> > Any input? I can reproduce these numbers consistently. If you need
> more
> > information then just let me know. By the way, I am a new postgresql
> user so
> > my experience is limited.
> 
> Maybe different compile options?  If we'd really slowed things down by 
> 50% between 8.4.3 and 8.4.4, there'd be an awful lot of people 
> screaming about it...

Given that there are 2 recent reports on the same issue, I wonder if the new packages were built with debugging options
ornot.
 

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz

pgsql-performance by date:

Previous
From: AI Rumman
Date:
Subject: query hangs
Next
From: Szymon Guz
Date:
Subject: Re: query hangs