On 5/22/21 4:11 PM, Tom Lane wrote:
> Soumya Prasad Ukil <soumyo_ju(at)yahoo(dot)co(dot)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 does not 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.