pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <janwieck@yahoo.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Gordon Clarke <gordonc@adf-serials.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Functions in Postgres
Date: Fri, 12 Apr 2002 14:07:32 -0400 (EDT)
Message-ID: <200204121807.g3CI7W407276@saturn.janwieck.net> (raw)
In-Reply-To: <Pine.LNX.4.30.0204121224160.847-100000@peter.localdomain>

Peter Eisentraut wrote:
> Gordon Clarke writes:
>
> > I was asking to see if there was any speed penalty with coding a fn in SQL
> > as opposed to PL/pgsql. It appears that there is and from what you've said
> > PL/pgsql is slightly faster than PL/TCL and probably PL/Perl. Am I correct
> > in drawing that conclusion?
>
> Yes, that seems about right.

    I  would  say it depends pretty much on what that function is
    doing.   PL/pgSQL  is  not  the  best  answer  to  do  string
    manipulation  and  such.  PL/Tcl can do that alot better, Tcl
    has it's own bytecode compiler since 8.0 (if memory  serves),
    and  if  the  programmer  cares,  it can cache query plans as
    well. As allways

    a)  Using the right tool for  a  problem  can  lead  to  good
        results.

    b)  A fool with a tool is still a fool.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #





view thread (11+ messages)  latest in thread

Message-ID: <200204121807.g3CI7W407276@saturn.janwieck.net>
Permalink:  ../200204121807.g3CI7W407276@saturn.janwieck.net/
Also on:    postgresql.org/message-id/200204121807.g3CI7W407276@saturn.janwieck.net

 · 

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-sql@postgresql.org
  Cc: janwieck@yahoo.com, peter_e@gmx.net, gordonc@adf-serials.com
  Subject: Re: Functions in Postgres
  In-Reply-To: <200204121807.g3CI7W407276@saturn.janwieck.net>

* 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