Re: Prepared query parsing much slower in 9.0?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Prepared query parsing much slower in 9.0?
Дата
Msg-id 4BBAF80E.3010306@dunslane.net
обсуждение исходный текст
Ответ на Re: Prepared query parsing much slower in 9.0?  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: Prepared query parsing much slower in 9.0?
Список pgsql-hackers

David E. Wheeler wrote:
> When I run the Bricolage test suite against 8.4 (12,700 assertions), it takes 45-50s on my MacBook Pro. When I run
themagainst 9.0, it takes 530-540s!
 
>
> Is there anything in the tree that has debugging turned on or something? I'm not at all sure that what Josh has found
canaccount for this 10x difference, can it (I ran the tests several times).
 
>
> Looking at the process table, postgresql never goes over 25% CPU on 8.4, but hovers at 90-95% on 9.0. To judge by the
waytest output is emitted, writes are particularly slow, but I can see some substantial delays on reads, too.
 
>
>   

This needs to be profiled. Otherwise we'd just be speculating on 
possible causes with no real hard data. (This is where tools like 
oprofile come in handy, but I have no idea if something similar is 
available on OSX.)

cheers

andrew


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

Предыдущее
От: Boszormenyi Zoltan
Дата:
Сообщение: Question about WAL and XID
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Question about WAL and XID