* Jan Urbański (wulc...@wulczer.org) wrote: > On 28/03/11 04:31, Tom Lane wrote: > >> Do the other PLs we ship need similar fixes? > > > > Offhand I think the other PLs leave management of prepared plans to the > > user. If there are any places where they cache plans behind the scenes, > > maybe a similar fix would be appropriate. > > FWIW I executed > > do $$ plpy.execute("select 1 from pg_class") $$ language plpythonu; > > 10k times in a session and the backend grew a lot in memory and never > released it. I can't offhand see where the memory went, I'll try to > investigate in the evening.
I'm about 90% sure that they all have this problem.. I havn't had a chance to look at how Tom fixed pl/pgsql (I didn't think it'd be easy to do w/o coming up with a way to explicitly tell the PL to release something) so perhaps I'm mistaken, but they all share very similar code.. Thanks, Stephen
signature.asc
Description: Digital signature