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

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Max Williams <Max(dot)Williams(at)mflow(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date: 2010-06-10 08:29:58
Message-ID: 1276158598.5764.22.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(dot)Williams(at)mflow(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2010-06-10 08:37:06 Re: InvalidXLogRecPtr in docs
Previous Message Max Williams 2010-06-10 08:18:12 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?

Browse pgsql-performance by date

  From Date Subject
Next Message Ambarish Bhattacharya 2010-06-10 08:47:48 Autovaccum settings while Bulk Loading data
Previous Message Max Williams 2010-06-10 08:18:12 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?