[PERFORM] it is always delete temp table will slow down the postmaster?

2005-08-10 Thread Chun Yit(Chronos)
hi, i got one situation here, i create one pl/pgsql function that using temp table to store temporary data. wherever i execute my function, i need to delete all the data inside the temp table, but this will slow down the searching function if i conitnue to run the server because old

[PERFORM] Postgresql7.4.5 running slow on plpgsql function

2005-06-27 Thread 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