Re: Cool PL/PgSQL hack :)

Sean,

> But, for the sake of testing, here are a few tests:

These are way cool. Mind posting an article on Techdocs with them? On on
Elein's site ... she asked me for an article ....

> PS I know the C examples didn't connect to the SPI manager, but it
> wasn't necessary for the tests given. Fetching rows is IO bound and
> my laptop's HDD isn't what I'd call server quality so I stuck to
> purely mathematical functions for now. pl/pgsql has a nasty habit of
> copying data with ROWTYPE's/RECORD's, whereas in C you can use a fixed
> buffer and just realloc() the space. *sigh* I wish pl/pgsql was
> smarter in that regard and would only really copy if the function had
> RETURN NEXT or returned a SETOF data.

FWIW, PL/plSQL was originally written by Jan Wieck as an intermediate step to
developing PL/tcl, which is what he uses. As such, the first version was
quite hackish, and was only moderately cleaned up by Great Bridge for Oracle
migration. A lot of the internals of PL/pgSQL are very inefficient and could
do with an overhaul.

On the up side, it still beats the pants of T-SQL for flexibility ....

--
Josh Berkus
Aglio Database Solutions
San Francisco