optimiser questions

Hello Hackers,

I had some performance problems with a plpgsql function I developped,
because the function is very costly (it involves querying tables) and the
query optimiser assumed basically that it was an inexpensive function.

I found a workaround, but the problem may worth being adressed:

Instead of doing:

filter costly_function(attribute of table1)
on join (table1, table2)

It did:

join(filter costly_function(attribute of table1) on table1,
table2)

This was a very bad idea, because table1 is much larger than join(table1,
table2) as some other low cost filtering conditions are available.

Question:

- how to tell the optimiser about the cost of an individual function
(I think that very costly would be enough).

I haven't found a clue about the issue in the documentation.
Maybe an additional field would be added to pg_proc and or pg_operator
is needed?

Have a nice day,

--
Fabien Coelho - coelho@cri.ensmp.fr