From: Jean-Max Reymond <jmreymond@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: perl garbage collector
Date: Wed, 29 Jun 2005 00:10:01 +0200
Message-ID: <4b09a0c0506281510239cbad4@mail.gmail.com> (raw)
In-Reply-To: <4b09a0c0506281147bc4b27f@mail.gmail.com>
References: <4b09a0c050627134660b3925@mail.gmail.com>
<11126.1119938006@sss.pgh.pa.us>
<4b09a0c0506281147bc4b27f@mail.gmail.com>
2005/6/28, Jean-Max Reymond <jmreymond@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jmreymond@gmail.com
Subject: Re: perl garbage collector
In-Reply-To: <4b09a0c0506281510239cbad4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox