Skip site navigation (1) Skip section navigation (2)

Re: User Defined Functions/AM's inherently slow?

From: Eric Ridge <ebr(at)tcdi(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: User Defined Functions/AM's inherently slow?
Date: 2004-03-29 06:01:56
Message-ID: 958F3A30-8146-11D8-BC9D-000A95BB5944@tcdi.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I don't have the original thread in my inbox anymore, so for reference:
	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



pgsql-hackers by date

Next:From: Tom LaneDate: 2004-03-29 06:05:54
Subject: Re: Fuzzy cost comparison to eliminate redundant planning work
Previous:From: Bruce MomjianDate: 2004-03-29 06:01:23
Subject: Re: Fuzzy cost comparison to eliminate redundant planning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group