Re: plpgsql function seems to be leaking memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Cousin <mcousin(at)sigma(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: plpgsql function seems to be leaking memory
Date: 2008-06-24 14:56:10
Message-ID: 16759.1214319370@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marc Cousin <mcousin(at)sigma(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Cousin 2008-06-24 15:29:09 Re: plpgsql function seems to be leaking memory
Previous Message C K 2008-06-24 10:43:38 Functions