""Chun Yit(Chronos)"" <ivanbeh(at)chronos(dot)com(dot)my> writes
>
>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.
A better way to empty a table fast is "truncate table".
Regards,
Qingqing