"Ian Harding" <ianh@tpchd.org> writes:
> It calls another function that now uses a temporary table. It
> creates, uses and drops the table. It is usually called only once per
> transaction, but it is called repeatedly from the main function in
> this case. When I run the function, the memory numbers reported by
> top climb quickly until it blows up. I wonder if this has anything to
> do with it.
This sounds like a memory leak inside plpgsql. We've plugged some of
those over the last few releases, but I bet there are more.
If you are not on 7.2.*, please update. If you are, could we see the
function definitions?
regards, tom lane