From: Stefan Weiss <spaceman@foo.at>
To: pgsql-performance@postgresql.org
Subject: Re: plperl vs plpgsql
Date: Sun, 17 Apr 2005 15:32:37 +0200
Message-ID: <42626575.6040604@foo.at> (raw)
In-Reply-To: <42625D0F.5050308@meerkatsoft.com>
References: <425FAA33.2000008@meerkatsoft.com>
<m3ekdc42pu.fsf@knuth.cbbrowne.com>
<42625D0F.5050308@meerkatsoft.com>
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.htmlhttp://www.postgresql.org/docs/8.0/static/plperl.html
HTH,
stefan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spaceman@foo.at
Subject: Re: plperl vs plpgsql
In-Reply-To: <42626575.6040604@foo.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox