Re: PL/pgSQL Memory Management? - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL Memory Management?
Date
Msg-id 12552.1014340350@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL Memory Management?  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
List pgsql-general
"Command Prompt, Inc." <pgsql-general@commandprompt.com> writes:
> ... how exactly does PL/pgSQL manage the memory it requires for
> calls to functions and operators?

7.1 and before leak like a sieve :-(, at least for the duration of a
single function call.

> Also, does 7.2's version of PL/pgSQL behave the same way?

7.2 should be much better, though I am too lazy to try your specific
example right now.  If you still see leakage under 7.2 please report it
and we'll try to fix it.

            regards, tom lane

pgsql-general by date:

Previous
From: Brent Wood
Date:
Subject: environment variables, output format & setting current date
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: environment variables, output format & setting current