Re: 8.3devel slower than 8.2 under read-only load - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: 8.3devel slower than 8.2 under read-only load
Date
Msg-id 200711261159.29762.peter_e@gmx.net
Whole thread Raw
In response to Re: 8.3devel slower than 8.2 under read-only load  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: 8.3devel slower than 8.2 under read-only load  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Autovacuum and OldestXmin
Next
From: "Guillaume Smet"
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load