Re: Prepared query parsing much slower in 9.0? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Prepared query parsing much slower in 9.0?
Date
Msg-id 4BBAF80E.3010306@dunslane.net
Whole thread Raw
In response to Re: Prepared query parsing much slower in 9.0?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Prepared query parsing much slower in 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List 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 by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: Question about WAL and XID
Next
From: Heikki Linnakangas
Date:
Subject: Re: Question about WAL and XID