Re: pl/* overhead ...

On Wed, Oct 26, 2005 at 12:58:13AM -0300, Marc G. Fournier wrote:
> Does anyone know of, or have, any comparisions of the overhead going with 
> something like pl/perl or pl/php vs using pl/pgsql?

Benchmark results will probably depend on the type of processing
you're doing.  I'd expect PL/pgSQL to be faster at database operations
like looping through query results, and other languages to be faster
at non-database operations like text munging and number crunching,
depending on the particular language's strengths.

[Does quick test.]

Whale oil beef hooked.  PL/pgSQL just outran PL/Perl when I expected
the latter to win.  Hang on, let me play with it until it comes back
with the results I want....

-- 
Michael Fuhr