Re: Postgres prepare statement caching issue in postgres command line

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Postgres prepare statement caching issue in postgres command line
Дата
Msg-id 8dde1b59-3763-260f-5958-563d9e6bc288@gmail.com
обсуждение исходный текст
Ответ на Re: Postgres prepare statement caching issue in postgres command line  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 5/22/21 4:11 PM, Tom Lane wrote:
> Soumya Prasad Ukil <soumyo_ju@yahoo.co.in> writes:
>> I have been using postgres prepare statement feature through JDBC. I could see the same prepare statement multiple
times,parsing is not happening in postgres backend, which is expected. However I do the same in psql command line, that
doesnot happen. It goes to parsing every time I execute
 
> Perhaps "set plan_cache_mode = force_generic_plan" would help you.
>
> Bear in mind that this is likely to be a net loss overall.

This (poorly) works around the problem, but does not answer the question.

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Framework for 0 downtime deploys
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgres prepare statement caching issue in postgres command line