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)
Список
Дерево обсуждения
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
Дата: