Re: Functions in Postgres - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Functions in Postgres
Date
Msg-id 200204121912.g3CJC1007563@saturn.janwieck.net
Whole thread Raw
In response to Re: Functions in Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane wrote:
> Jan Wieck <janwieck@yahoo.com> writes:
> > Tom Lane wrote:
> >> Not since about Tcl 8.0.
>
> >     You're right, not Tcl's fault. Noone changed PL/Tcl to use it
> >     though. It  still  does  Tcl_CreateCommand(),  which  is  the
> >     backward   compatibility   pure   string  interface  wrapping
> >     technology. :-)
>
> I could be mistaken, but I thought Tcl would still reduce the function
> text to bytecode behind-the-scenes.
>
> We are losing with unnecessary text conversions in a number of places in
> pltcl, but I think it's just in parameter passing at pltcl function
> entry/exit and calls to the special Tcl commands provided by pltcl.
> If you're executing regular Tcl commands inside a pltcl function,
> I think you still will get benefit from Tcl 8's speedups.
   Absolutely. It's only all the SPI_* crap and parameter/result   conversion.  Inside Tcl it's calm like in  the
center of  a   hurricane, the problem is just getting in and out...
 


Jan

--

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




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Functions in Postgres
Next
From:
Date:
Subject: Re: Problem With A Rule (clear version)