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/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
