X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 850615299C for ; Tue, 28 Jun 2005 02:53:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27335-06 for ; Tue, 28 Jun 2005 05:53:27 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 358EB52992 for ; Tue, 28 Jun 2005 02:53:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5S5rQ8I011127; Tue, 28 Jun 2005 01:53:26 -0400 (EDT) To: Jean-Max Reymond Cc: pgsql-performance@postgresql.org Subject: Re: perl garbage collector In-reply-to: <4b09a0c050627134660b3925@mail.gmail.com> References: <4b09a0c050627134660b3925@mail.gmail.com> Comments: In-reply-to Jean-Max Reymond message dated "Mon, 27 Jun 2005 22:46:48 +0200" Date: Tue, 28 Jun 2005 01:53:26 -0400 Message-ID: <11126.1119938006@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/538 X-Sequence-Number: 13175 Jean-Max Reymond 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