Postgres Professional
   

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

From: Max Williams
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Date: ,
Msg-id: 0357196CB603794BB76F4F6B373F27330506EACE55@SERVER.ddnglobal.local
(view: Whole thread, Raw)
In response to: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane)
Responses: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  ("Kevin Grittner")
Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane)
List: pgsql-performance

Tree view

Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams, )
 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  ("Pierre C", )
 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Robert Haas, )
  Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams, )
  Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Devrim GÜNDÜZ, )
   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams, )
    Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane, )
     Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams, )
      Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  ("Kevin Grittner", )
       Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Max Williams, )
        Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane, )
         Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Alvaro Herrera, )
          Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Lacey Powers, )
        Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Greg Smith, )
      Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Tom Lane, )
 Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (John Reeve, ) 
I'm afraid pg_config is not part of the pgdg packages.


-----Original Message-----
From: Tom Lane [mailto:]
Sent: 10 June 2010 15:11
To: Max Williams
Cc: 
Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

Max Williams <> writes:
> How do I tell if it was built with debugging options?

Run pg_config --configure and see if --enable-cassert is mentioned.

            regards, tom lane

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