[prev in list] [next in list] [prev in thread] [next in thread] 

List:       netsaint-devel
Subject:    RE: [netsaint-devel] Postgres Memory Leak Fixed
From:       Scott.Allen () hq ! com
Date:       2001-06-18 16:48:41
[Download RAW message or body]

Ah, I should have been more vocal about what I was up to:)  It looks like
Ethan, Karl, and I all did the same work, three times over:)  I finally
managed to find the leak on my own, in the same place you both did, using
memprof. I was waiting to see how it ran for a few days before I released a
patch.

Regardless, Ethan, your fix looks more complete than mine.  Thanks for
looking at this so quickly.  I'll be sure to speak up if it looks like the
leak persists.

Thanks again,

Scott Allen
HQ Global Workplaces / Lead System Administrator

> -----Original Message-----
> From: Ethan Galstad [mailto:netsaint@netsaint.org]
> Sent: Sunday, June 17, 2001 9:54 PM
> To: netsaint-devel@lists.sourceforge.net
> Subject: [netsaint-devel] Postgres Memory Leak Fixed
> 
> 
> I believe I had found and fixed the memory leak that users have 
> been reporting when using a Postgres DB as the backend for 
> storage of status (and other) data.  Hopefully the fixes I 
> made didn't 
> break anything else.  The patched code can be grabbed from CVS.
> 
> Basically what happened is that I failed to carefully read the 
> PostgreSQL development docs carefully.  I wasn't freeing memory 
> after queries that didn't return recordsets (i.e. INSERTs and 
> DELETEs).  My testing showed memory being leaked at the rate of 
> about 9MB per hour, although this could be more or less for you 
> depending on the number of services/hosts you have, as the leak 
> rate corresponded to the number of queries that were being 
> executed.
> 
> Anyway, give the code a try if you have an interest in using 
> PostgreSQL as your backend and let me know if you run across 
> further problems.
> 
> 
> 
> 
> 
> Ethan Galstad
> NetSaint Developer
> ---
> Email:   netsaint@netsaint.org
> Website: http://www.netsaint.org
> 
> _______________________________________________
> Netsaint-devel mailing list
> Netsaint-devel@lists.sourceforge.net
> http://lists.sourceforge.net/lists/listinfo/netsaint-devel
> 

_______________________________________________
Netsaint-devel mailing list
Netsaint-devel@lists.sourceforge.net
http://lists.sourceforge.net/lists/listinfo/netsaint-devel

[prev in list] [next in list] [prev in thread] [next in thread]