Re: Prepared query parsing much slower in 9.0?

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