Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql function seems to be leaking memory - Mailing list pgsql-admin

From Tom Lane
Subject Re: plpgsql function seems to be leaking memory
Date
Msg-id 16759.1214319370@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql function seems to be leaking memory  (Marc Cousin <mcousin@sigma.fr>)
Responses Re: plpgsql function seems to be leaking memory
Re: plpgsql function seems to be leaking memory
List pgsql-admin
Tree view 
Marc Cousin <mcousin@sigma.fr> writes:
> I'm having a problem with plpgsql functions leaking memory.

Your example shows absolutely no memory leak here, in either 8.3.3
or CVS HEAD.

> I see the postgresql process growing from 8MB to about 400 MB during this
> run...

What do you have shared_buffers set to?  I think you might be getting
fooled by top's treatment of shared memory (ie, it starts to count
shared pages after the process touches them for the first time).

            regards, tom lane

pgsql-admin by date:

Previous
From: "C K"
Date:
Subject: Functions
Next
From: Marc Cousin
Date:
Subject: Re: plpgsql function seems to be leaking memory