[PERFORM] Postgresql7.4.5 running slow on plpgsql function

[Chun Yit(Chronos)]

>hi, need some help with some experts here. >currently we have a function that use together with temp table, it calls search result function, everytime >this function is calling, it will go through some filter before come out as a result. >now we have some major problem , the first time the function execute, it take about 13 second >second time the function is execute, it take about 17 second, every time you execute the function >the time taken will grow about 4 second, ? >may i know what going on here? >since we use function with temp table, so every statement that related to temp table will using EXECUTE >command. > >regards >ivan