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 A7B8E53475 for ; Sun, 17 Apr 2005 10:57:15 -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 81850-07 for ; Sun, 17 Apr 2005 13:57:11 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id D10F253429 for ; Sun, 17 Apr 2005 10:57:10 -0300 (ADT) Received: from hosting.commandprompt.com (hosting.commandprompt.com [192.168.1.101]) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j3HDpcmb013992; Sun, 17 Apr 2005 06:51:38 -0700 Date: Sun, 17 Apr 2005 06:51:38 -0700 (PDT) From: "Joshua D. Drake" To: Alex Cc: Christopher Browne , pgsql-performance@postgresql.org Subject: Re: plperl vs plpgsql In-Reply-To: <42625D0F.5050308@meerkatsoft.com> Message-ID: References: <425FAA33.2000008@meerkatsoft.com> <42625D0F.5050308@meerkatsoft.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.026 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/380 X-Sequence-Number: 11777 On Sun, 17 Apr 2005, Alex wrote: > Is there a performance difference between the two? Hello, It depends on what you are using it for. My experience is that for some reason plPGSQL is faster when looping but other than that they should be very similar. > which of the PL is most widely used. One problem i have with the plpgsql is > that the quoting is really a pain. plpgsql but I believe that will change in a short period of time. Sincerely, Joshua D. Drake -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/