Re: Postgres prepare statement caching issue in postgres command line - Mailing list pgsql-general

From Ron
Subject Re: Postgres prepare statement caching issue in postgres command line
Date
Msg-id 8dde1b59-3763-260f-5958-563d9e6bc288@gmail.com
Whole thread Raw
In response to Re: Postgres prepare statement caching issue in postgres command line  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Framework for 0 downtime deploys
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres prepare statement caching issue in postgres command line