[postgis-users] pl/pgsql vs. C functions

[Paul Ramsey]

Probably you could get a definitive answer on one of the pgsql lists.
However, my uninformed impression is that PL/PgSQL is interpretted, like
PL/Perl and PL/TCL, so there is definately a speed hit relative to an
equivalent C algorithm. Of course, implementation counts as well as
language -- a brain-dead implementation will be slow regardless of
language choice... YMMV :/

P.


"Robert W. Burgholzer" wrote:
> 
> I was wondering if anyone could shed some light on the relative speed
> advantages of C over pgpsql functions, if any exist.
> I am doing some geo-processing stuff and feel like I am not getting
> much speed out of the pl/pgsql stuff.
> 
> Thanks,
> 
> Rob
> 
> 
> --
> Robert Burgholzer
> al·go·rithm  n.
>        A step-by-step problem-solving procedure, especially an established, recursive computational
>        procedure for solving a problem in a finite number of steps. Invented by Al Gore.
> rburghol at vt.edu
> http://www.soulswimmer.net/
> 
>