Re: 8.3devel slower than 8.2 under read-only load

Am Samstag, 24. November 2007 schrieb Simon Riggs:
> In many cases, 100% of queries are unprepared.

I have seen many applications where prepared queries caused stale plans and 
poor performance.  We have in many cases achieved great performance gains by 
turning off prepared queries globally, for example in the driver layer.  It 
had once gotten to a point where "uses prepared statements" was on par 
with "never touched postgresql.conf" and "never heard of VACUUM" as the worst 
performance sins.  I will gladly revisit this with 8.3, but I am not very 
optimistic.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/