Postgres Pro
Downloads
Home   >   mailing lists

Re: Perl function leading to out of memory error - Mailing list pgsql-general

From Tom Lane
Subject Re: Perl function leading to out of memory error
Date
Msg-id 25244.1361274074@sss.pgh.pa.us
Whole thread Raw
In response to Perl function leading to out of memory error  (Jan Strube <js@deriva.de>)
Responses Re: Perl function leading to out of memory error  (Christian Schröder <cs@deriva.de>)
List pgsql-general
Tree view 
Jan Strube <js@deriva.de> writes:
> we have a Java daemon that´s repeatedly calling a Perl function inside
> our database (version 9.1.8). The function is called about 200 times per
> second. While the Java program is running you can watch the memory usage
> of the postmaster grow continuously until after a few hours we get an
> out of memory error from Postgres. In the log you see a lot of
> "ExprContext..." messages.

I tried to reproduce this, without much success.  Can you extract a
self-contained test case?

            regards, tom lane

pgsql-general by date:

Previous
From: patrick keshishian
Date:
Subject: Re: Terminate query on page exit
Next
From: Pavel Stehule
Date:
Subject: Re: Terminate query on page exit