X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 506EF5372D for ; Sun, 17 Apr 2005 10:32:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74298-10 for ; Sun, 17 Apr 2005 13:32:45 +0000 (GMT) Received: from viefep20-int.chello.at (viefep12-int.chello.at [213.46.255.25]) by svr1.postgresql.org (Postfix) with ESMTP id 11D7B5371B for ; Sun, 17 Apr 2005 10:32:42 -0300 (ADT) Received: from [213.47.56.254] by viefep20-int.chello.at (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20050417133245.RECG29474.viefep20-int.chello.at@[213.47.56.254]> for ; Sun, 17 Apr 2005 15:32:45 +0200 Message-ID: <42626575.6040604@foo.at> Date: Sun, 17 Apr 2005 15:32:37 +0200 From: Stefan Weiss Organization: Foo Orbital Operations User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: plperl vs plpgsql References: <425FAA33.2000008@meerkatsoft.com> <42625D0F.5050308@meerkatsoft.com> In-Reply-To: <42625D0F.5050308@meerkatsoft.com> Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.031 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/379 X-Sequence-Number: 11776 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