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

Поиск
Список
Период
Сортировка
От Guillaume Smet
Тема Re: 8.3devel slower than 8.2 under read-only load
Дата
Msg-id 1d4e0c10711260312h513cac07s9c037c720e0861c1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.3devel slower than 8.2 under read-only load  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: 8.3devel slower than 8.2 under read-only load
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum and OldestXmin