Re: [GENERAL] Perl function leading to out of memory error

2013-02-22 Thread Christian Schröder
On 21.02.2013 01:02, Jeff Janes wrote: CREATE DOMAIN isin AS char(12) CHECK (isin_ok(value)); Could you give some example values that meet this criteria? Trying to reverse engineer your helper functions is no fun. A valid example is "DE000710". The same with another check digit is of cours

Re: [GENERAL] Perl function leading to out of memory error

2013-02-20 Thread Jeff Janes
On Wed, Feb 20, 2013 at 9:31 AM, Christian Schröder wrote: > after some investigation it seems that the error has to do with a domain > type that we have defined in our database. We have defined the following > helper functions: > ... > > CREATE DOMAIN isin AS char(12) CHECK (isin_ok(value)); Co

Re: [GENERAL] Perl function leading to out of memory error

2013-02-20 Thread Toby Corkindale
On 19/02/13 22:05, Jan Strube wrote: 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 a

Re: [GENERAL] Perl function leading to out of memory error

2013-02-20 Thread Christian Schröder
On 19.02.2013 12:41, Tom Lane wrote: Jan Strube 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 gro

Re: [GENERAL] Perl function leading to out of memory error

2013-02-20 Thread Vincent Veyron
Le mardi 19 février 2013 à 12:05 +0100, Jan Strube a écrit : > Hi, > > 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 > o

Re: [GENERAL] Perl function leading to out of memory error

2013-02-19 Thread Tom Lane
Jan Strube 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 f

[GENERAL] Perl function leading to out of memory error

2013-02-19 Thread Jan Strube
Hi, 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 ou