Currently, pl/tcl is implemented through nothing but string
manipulation. In other words, the C code is effectively creating a giant
string that the tcl interpreter must re-parse every time the function is
executed. Additionally, all arguments are treated as raw strings,
instead of the far more efficient internal tcl object types.
The biggest win comes with how pltcl interfaces with SPI result sets.
Currently, the entire chunk of tcl code that is executed for each result
row must be reparsed and recompiled from scratch. Now, the code is
compiled once and the bytecode is stored.
This work is sponsored by Flight Aware (http://flightaware.com/).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com