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
Ответ на
Список
Дерево обсуждения
Reusing cached prepared statement slow after 5 executions Rob Gansevles <rgansevles@gmail.com>
Re: Reusing cached prepared statement slow after 5 executions David Johnston <polobo@yahoo.com>
Re: Reusing cached prepared statement slow after 5 executions Tom Lane <tgl@sss.pgh.pa.us>
Re: Reusing cached prepared statement slow after 5 executions Rob Gansevles <rgansevles@gmail.com>
Re: Reusing cached prepared statement slow after 5 executions Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Reusing cached prepared statement slow after 5 executions "Albe Laurenz" <laurenz.albe@wien.gv.at>
David Johnston  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
Дата:
От: Stephen Frost
Дата:
FAQ