Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Smith
Subject Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date
Msg-id 4C1147F0.2090607@2ndquadrant.com
Whole thread Raw
In response to Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams <Max.Williams@mflow.com>)
List pgsql-performance
Tree view 
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@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: Need to increase performance of a query
Next
From: Anne Rosset
Date:
Subject: Re: Need to increase performance of a query