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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Max Williams <Max(dot)Williams(at)mflow(dot)com>
Cc: "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 20:15:44
Message-ID: 4C1147F0.2090607@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-06-10 20:39:50 including backend ID in relpath of temp rels - updated patch
Previous Message Simon Riggs 2010-06-10 20:09:05 Re: Command to prune archive at restartpoints

Browse pgsql-performance by date

  From Date Subject
Next Message Anne Rosset 2010-06-10 20:21:44 Re: Need to increase performance of a query
Previous Message Joe Conway 2010-06-10 20:13:46 Re: Need to increase performance of a query