Re: plperl vs plpgsql

From: Stefan Weiss
Subject: Re: plperl vs plpgsql
Date: ,
Msg-id: 42626575.6040604@foo.at
(view: Whole thread, Raw)
In response to: Re: plperl vs plpgsql  (Alex)
List: pgsql-performance

Tree view

plperl vs plpgsql  (Alex, )
 Re: plperl vs plpgsql  (Christopher Browne, )
  Re: plperl vs plpgsql  (Alex, )
   Re: plperl vs plpgsql  (Stefan Weiss, )
   Re: plperl vs plpgsql  ("Joshua D. Drake", )
 Re: plperl vs plpgsql  (Christopher Browne, )

On 2005-04-17 14:56, Alex wrote:
> Is there a performance difference between the two?

As Christopher already pointed out, it depends on what you want to do.
If you're doing some complex string processing, it will be easier (and
in some cases) faster to do in plperl, if you're mainly dealing with
sets, plpgsql will be better suited.

> which of the PL is most widely used.

plpgsql.

> One problem i have with the plpgsql
> is that the quoting is really a pain.

In current versions of PostgreSQL you can use $$ quoting, which should
make your life easier:
http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html
http://www.postgresql.org/docs/8.0/static/plperl.html


HTH,
stefan


pgsql-performance by date:

From: "Joshua D. Drake"
Date:
Subject: Re: plperl vs plpgsql
From: "Rüdiger Herrmann"
Date:
Subject: refcurosr vs. setof