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

From Devrim GÜNDÜZ
Subject Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date
Msg-id 1276158598.5764.22.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams <Max.Williams@mflow.com>)
List pgsql-performance
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 or not.

--
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

Attachment

pgsql-performance by date:

Previous
From: Max Williams
Date:
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Next
From: Ambarish Bhattacharya
Date:
Subject: Autovaccum settings while Bulk Loading data