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/