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: 15383.1276179056@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?  (Max Williams)
Список: 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:
> 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 по дате сообщения:

От: Joe Conway
Дата:
Сообщение: Re: Need to increase performance of a query
От: Joe Conway
Дата:
Сообщение: Re: Need to increase performance of a query