Обсуждение: Plans cache eviction from process local Memory

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