Re: [Sqlgrey-users] Solution to sqlgrey & postgresql memory leaks?

[Karl O. P. <ko...@me...>]

On 08/05/2007 01:41:10 PM, Lionel Bouton wrote:
> Adam Sjøgren wrote the following on 05.08.2007 20:32 :
> >
> > What is then causing this loop of a common sqlgrey-query to leak?

> Here
> 
> is what I think happens:
> 
> InactiveDestroy => 1 is used to support asynchronsous cleaning of the
> DB
> (which is quite buggy, I never understood why and still recommend to
> leave it deactivated unless it really stalls the server too long and
> asynchronous cleaning actually works for you).

FYI I'm pretty sure the leak is perl related.  I didn't have one,
in either sqlgrey or postgresql, until upgrading from Debian sarge
to etch.  I believe this left the postgresql version unchanged at 7.4,
and the sqlgrey was unchanged.  That leaves the problem on
perl's doorstep, most likely.

Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein