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 #
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