pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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...
>  
>





view thread (6+ messages)  latest in thread

Message-ID: <42625D0F.5050308@meerkatsoft.com>
Permalink:  ../42625D0F.5050308@meerkatsoft.com/
Also on:    postgresql.org/message-id/42625D0F.5050308@meerkatsoft.com

 · 

reply

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