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: 0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local
(см: обсуждение, исходный текст)
Ответ на: 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?  (Tom Lane)
Список: 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, )

How do I tell if it was built with debugging options?


-----Original Message-----
From: Devrim GÜNDÜZ [mailto:] 
Sent: 10 June 2010 09:30
To: Robert Haas
Cc: Max Williams; 
Subject: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?

On Wed, 2010-06-09 at 21:51 -0400, Robert Haas wrote:
> On Wed, Jun 9, 2010 at 6:56 AM, Max Williams <>
> wrote:
> > Any input? I can reproduce these numbers consistently. If you need
> more
> > information then just let me know. By the way, I am a new postgresql
> user so
> > my experience is limited.
> 
> Maybe different compile options?  If we'd really slowed things down by 
> 50% between 8.4.3 and 8.4.4, there'd be an awful lot of people 
> screaming about it...

Given that there are 2 recent reports on the same issue, I wonder if the new packages were built with debugging options
ornot.
 

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz


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

От: 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?