Plans cache eviction from process local Memory - Mailing list pgsql-general

From pinker
Subject Plans cache eviction from process local Memory
Date
Msg-id 1528363973507-0.post@n3.nabble.com
Whole thread Raw
List pgsql-general
Hi!
I would like to know how postgres will behave with a big amount of cached
plans from prepared statements on 1 connection. Let's say there is an
application level connection pooling and one connection can last for many
weeks. Many plans are cached from many prepared statements, is there any
postgres management of that or it is totally system thing? 
Some plans will be evicted from process memory at some point of time or they
will be kept infinitely causing huge amount of memory being allocated for
this connection?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


pgsql-general by date:

Previous
From: Christoph Berg
Date:
Subject: Re: iso-8859-1 database folders in base directory
Next
From: Raymond O'Donnell
Date:
Subject: Re: Code of Conduct plan