Re: PLPERL Function very Slow - Mailing list pgsql-general

From Tom Lane
Subject Re: PLPERL Function very Slow
Date
Msg-id 27930.1156951190@sss.pgh.pa.us
Whole thread Raw
In response to PLPERL Function very Slow  (Alex <alex@meerkatsoft.com>)
List pgsql-general
Alex <alex@meerkatsoft.com> writes:
> The initial select is pretty fast and first inserts very fast, but after
> a few thousand inserts the inserts start to slow down until it crawls.
> Writing the same in a normal perl script takes less than 90 seconds
> while the function is taking 10 minutes.

Can you provide a self-contained test case that shows this behavior?

            regards, tom lane

pgsql-general by date:

Previous
From: "Enrique Alejandro Barrios"
Date:
Subject: SQL Tuning
Next
From: "Clodoaldo Pinto"
Date:
Subject: Re: Postgres