[PERFORM] it is always delete temp table will slow down the postmaster?
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 tuples are not really clear if just using delete command. so i use drop table command and recreate the table. my question is, would it slow down the postmaster speed if i continue to run this searching function more than 300 time per day?, cause the speed for execute searching function will graduatelly increase after i test it for few day? anyway to test it is causing by the drop temp table and create temp table command? regards ivan
[PERFORM] Postgresql7.4.5 running slow on plpgsql function
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, ? mayi 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