Re: pl/* overhead ... - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: pl/* overhead ...
Date
Msg-id 20051026065542.GA19386@winnie.fuhr.org
Whole thread Raw
In response to pl/* overhead ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: pl/* overhead ...
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Bath, David"
Date:
Subject: Re: why vacuum
Next
From: Tom Lane
Date:
Subject: Re: why vacuum