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

From Tom Lane
Subject Re: Postgres prepare statement caching issue in postgres command line
Date
Msg-id 283195.1621717881@sss.pgh.pa.us
Whole thread Raw
In response to Postgres prepare statement caching issue in postgres command line  (Soumya Prasad Ukil <soumyo_ju@yahoo.co.in>)
Responses Re: Postgres prepare statement caching issue in postgres command line
List pgsql-general
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.

            regards, tom lane



pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
Next
From: Bruce Momjian
Date:
Subject: Re: Framework for 0 downtime deploys