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

Re: perl garbage collector

From: Jean-Max Reymond <jmreymond(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: perl garbage collector
Date: 2005-06-28 22:10:01
Message-ID: 4b09a0c0506281510239cbad4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2005/6/28, Jean-Max Reymond <jmreymond(at)gmail(dot)com>:
> For my application (in real life) afer millions of spi_exec_query, it
> grows up to 1Gb :-(

OK, now in 2 lines:

CREATE FUNCTION jmax() RETURNS integer
    AS $_$use strict;

for (my $i=0; $i<10000000;$i++) {
        spi_exec_query("select 'foo'");
}
my $j=1;$_$
    LANGUAGE plperlu SECURITY DEFINER

running this test and your postmaster eats a lot of memory.
it seems that there is a memory leak  in spi_exec_query :-( 


-- 
Jean-Max Reymond
CKR Solutions Open Source
Nice France
http://www.ckr-solutions.com

In response to

pgsql-performance by date

Next:From: Bruce MomjianDate: 2005-06-28 23:14:41
Subject: Re: COPY FROM performance improvements
Previous:From: Matthew NuzumDate: 2005-06-28 21:55:44
Subject: Re: optimized counting of web statistics

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