Re: perl garbage collector - Mailing list pgsql-performance

From Tom Lane
Subject Re: perl garbage collector
Date
Msg-id 11126.1119938006@sss.pgh.pa.us
Whole thread Raw
In response to perl garbage collector  (Jean-Max Reymond <jmreymond@gmail.com>)
Responses Re: perl garbage collector
List pgsql-performance
Jean-Max Reymond <jmreymond@gmail.com> writes:
> I have a stored procedure written in perl and I doubt that perl's
> garbage collector is working :-(
> after a lot of work, postmaster has a size of 1100 Mb and  I think
> that the keyword "undef" has no effects.

Check the PG list archives --- there's been previous discussion of
similar issues.  I think we concluded that when Perl is built to use
its own private memory allocator, the results of that competing with
malloc are not very pretty :-(.  You end up with a fragmented memory
map and no chance to give anything back to the OS.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How are text columns stored?
Next
From: Gnanavel Shanmugam
Date:
Subject: Re: How can I speed up this function?