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

From Guillaume Smet
Subject Re: 8.3devel slower than 8.2 under read-only load
Date
Msg-id 1d4e0c10711260312h513cac07s9c037c720e0861c1@mail.gmail.com
Whole thread Raw
In response to Re: 8.3devel slower than 8.2 under read-only load  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Nov 26, 2007 11:59 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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.

+1 on this point as I explained it earlier.

--
Guillaume


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum and OldestXmin