Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group