Hartmut,
> DELETE:
> 1) 0.03u 0.04s 0:02.46 2.8% (already empty)
> 2) 0.05u 0.06s 0:01.19 9.2% (already empty)
>
> TRUNCATE:
> 1) 0.10u 0.06s 6:58.66 0.0% (already empty, compile runnig simult.)
> 2) 0.10u 0.02s 2:51.71 0.0% (already empty)
How about some times for a full table?
Incidentally, I believe that TRUNCATE has always been slightly slower than
DROP TABLE.
--
Josh Berkus
Aglio Database Solutions
San Francisco