Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
От | John Reeve |
---|---|
Тема | Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? |
Дата | |
Msg-id | loom.20100611T183107-148@post.gmane.org обсуждение исходный текст |
Ответ на | 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, )
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, )
Greg Smith <greg <at> 2ndquadrant.com> writes: > > Max Williams wrote: > > Can I just turn this off on 8.4.4 or is it a compile time option > > You can update your postgresql.conf to include: > > debug_assertions = false > > And restart the server. This will buy you back *some* of the > performance loss but not all of it. Will have to wait for corrected > packaged to make the issue completely go away. > Ah! I am so thankful I found this thread. We've been having the same issues described here. And when I do a SHOW debug_assertions I get: postgres=# show debug_assertions; debug_assertions ------------------ on (1 row) Can you let us know when the corrected packages have become available? Regards, John
В списке pgsql-performance по дате отправления: