>
>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] it is always delete temp table will slow down ... Chun Yit(Chronos)
- Re: [PERFORM] it is always delete temp table will s... Qingqing Zhou
- Re: [PERFORM] it is always delete temp table wi... Chun Yit(Chronos)