PL/PGSQL and PL/Perl time issues

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: PL/PGSQL and PL/Perl time issues
Date: 2002-03-19 17:38:58
Message-ID: a78jrf$29mq$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a PL/PGSQL routine that does one select and a lot (~400 lines) of
floating point computations. In rapid succession my JDBC application calls
this routine about 170 times. It gets slower as time drags on, taking
around 5 seconds per call at the beginning and ending up taking about 15
seconds per call at the end.

I have a much shorter (about 10 lines), but less efficient PL/Perl routine
that accomplishes the same computation, but does a lot of string matching
and runs slower. But the same problem occurs Each call takes longer the
more I call it.

Are there postgress issues I should be aware of regarding calling pl/pgsql
and pl/perl routines, or using JDBC to call these routines? Is there a way
to prevent this increase in time?

Thanks,
--
Travis Bauer
http://www.cs.indiana.edu/~trbauer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2002-03-19 18:04:24 Re: Reference pg_user ?
Previous Message Oliver Elphick 2002-03-19 17:14:24 Re: getting trigger to work