On 26.04.2017 04:00, Tsunakawa, Takayuki wrote:
Right now them are destroyed only in case of receiving invalidation
message (when catalog is changed).
Prepared statements are local to backend and are located in backend's
It is unlikely, that there will be too much different queries which
cause memory overflow.
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Konstantin
Well, first of all I want to share results I already get: pgbench with default
parameters, scale 10 and one connection:
So autoprepare is as efficient as explicit prepare and can increase
performance almost two times.
This sounds great.
BTW, when are the autoprepared statements destroyed?
But in theory such situation is certainly possible.
In this case we need some kind of LRU for maintaining cache of
I think that it is good idea to have such limited cached - it can avoid
memory overflow problem.
Are you considering some upper limit on the number of prepared statements?
I will try to implement it.
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: