From: Alex <alex@meerkatsoft.com>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: plperl vs plpgsql
Date: Sun, 17 Apr 2005 22:56:47 +1000
Message-ID: <42625D0F.5050308@meerkatsoft.com> (raw)
In-Reply-To: <m3ekdc42pu.fsf@knuth.cbbrowne.com>
References: <425FAA33.2000008@meerkatsoft.com>
<m3ekdc42pu.fsf@knuth.cbbrowne.com>
Is there a performance difference between the two?
which of the PL is most widely used. One problem i have with the plpgsql
is that the quoting is really a pain.
Christopher Browne wrote:
>After takin a swig o' Arrakan spice grog, alex@meerkatsoft.com (Alex) belched out:
>
>
>>i am thinking about swiching to plperl as it seems to me much more
>>flexible and easier to create functions.
>>
>>what is the recommended PL for postgres? or which one is most widely
>>used / most popular?
>>is there a performance difference between plpgsql and plperl ?
>>
>>
>
>If what you're trying to do is "munge text," pl/perl will be a whole
>lot more suitable than pl/pgsql because it has a rich set of text
>mungeing tools and string functions which pl/pgsql lacks.
>
>If you intend to do a lot of work involving reading unmunged tuples
>from this table and that, pl/pgsql provides a much more natural
>syntax, and will probably be a bit faster as the query processor may
>even be able to expand some of the actions, rather than needing to
>treat Perl code as an "opaque blob."
>
>I would definitely be inclined to use the more natural language for
>the given task...
>
>
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: alex@meerkatsoft.com, cbbrowne@acm.org
Subject: Re: plperl vs plpgsql
In-Reply-To: <42625D0F.5050308@meerkatsoft.com>
* 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