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?
Дата: ,
Msg-id: 0357196CB603794BB76F4F6B373F27330506EACE56@SERVER.ddnglobal.local
(см: обсуждение, исходный текст)
Ответ на: 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)
Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?  (Greg Smith)
Список: pgsql-performance

Скрыть дерево обсуждения

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

Ah, yes its OFF for 8.4.3 and ON for 8.4.4!

Can I just turn this off on 8.4.4 or is it a compile time option?
Also is this a mistake or intended? Perhaps I should tell the person who builds the pgdg packages??

Cheers,
Max


-----Original Message-----
From: Kevin Grittner [mailto:]
Sent: 10 June 2010 16:16
To: Max Williams; 
Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

Max Williams <> wrote:

> I'm afraid pg_config is not part of the pgdg packages.

Connect (using psql or your favorite client) and run:

show debug_assertions;

-Kevin


В списке pgsql-performance по дате сообщения:

От: Anne Rosset
Дата:
Сообщение: Re: Need to increase performance of a query
От: David Jarvis
Дата:
Сообщение: Re: Analysis Function