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?
Дата
Msg-id 17509.1276184785@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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?  (Alvaro Herrera)
Список 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, )
Max Williams <> writes:
> Ah, yes its OFF for 8.4.3 and ON for 8.4.4!

Hah.

> Can I just turn this off on 8.4.4 or is it a compile time option?

Well, you can turn it off, but that will only buy back part of the
cost (and not even the bigger part, I believe).

> Also is this a mistake or intended? Perhaps I should tell the person who builds the pgdg packages??

Yes, the folks at commandprompt need to be told about this.  Loudly.
It's a serious packaging error.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Anne Rosset
Дата:
Сообщение: Re: Need to increase performance of a query
Следующее
От: David Jarvis
Дата:
Сообщение: Re: Analysis Function