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 "Gregory Williamson" <Gregory.Williamson@digitalglobe.com>
Re: 8.3devel slower than 8.2 under read-only load "Guillaume Smet" <guillaume.smet@gmail.com>
On Nov 26, 2007 11:59 AM, Peter Eisentraut  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
Дата:
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum and OldestXmin
FAQ