Re: [PERFORM] index on custom function; explain

2005-10-06 Thread Andrew McMillan
On Tue, 2005-10-04 at 03:10 -0700, Jan Aerts wrote: > Some additional thoughts: what appears to take the most time (i.e. > account for the highest cost in the explain), is _not_ running the > function itself (cost=0.00..0.01), but comparing the result from that > function with the name1 column in t

Re: [PERFORM] index on custom function; explain

2005-10-06 Thread Yann Michel
Hi, On Mon, Oct 03, 2005 at 08:14:11AM -0700, [EMAIL PROTECTED] wrote: > So my questions are: > * Does anyone have any idea how I can integrate a function that lists > all aliases for a given name into such a mapping query? what version are you using? TIP 9: In versions below 8.0, the planner wi

Re: [PERFORM] index on custom function; explain

2005-10-04 Thread Jan Aerts
Some additional thoughts: what appears to take the most time (i.e. account for the highest cost in the explain), is _not_ running the function itself (cost=0.00..0.01), but comparing the result from that function with the name1 column in the mappings table (cost=0.00..35935.05). Am I right? (See EX