""Chun Yit(Chronos)"" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq