Re: Reusing cached prepared statement slow after 5 executions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reusing cached prepared statement slow after 5 executions
Дата
Msg-id 11490.1309101104@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reusing cached prepared statement slow after 5 executions  (David Johnston <polobo@yahoo.com>)
Ответы Re: Reusing cached prepared statement slow after 5 executions  (Rob Gansevles <rgansevles@gmail.com>)
Список pgsql-general
David Johnston <polobo@yahoo.com> writes:
> This is likely the case where the first few "prepared statements" are
> not truly prepared.  Once you hit five the cache kicks in and computes
> a generic query plan to cache.

Not so much that as that JDBC decides that it should tell the backend to
start using a prepared plan.  See the JDBC docs.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Reusing cached prepared statement slow after 5 executions
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: An amusing MySQL weakness--not!