http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF -8&selm=20129.1074484755%40sss.pgh.pa.us
Tom Lane last said:
I have committed a patch into CVS HEAD --- give it a try.
It took me awhile, but I finally got around to trying this (by plopping it into my 7.4 sources), and yes, the hashlookup does significantly improve the performance of calling "C" functions. I agree with your commit message that they're now roughly on par with built-in functions.
thanks!
eric
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
