has anyone else noticed a huge difference in "DELETE TABLE "
vs. "TRUNCATE " starting w/postgres 7.4?
putting aside details (num rows, indexes): ca. 300 tables
(already empty if desired...) ALL to be emptied (via batch file).
here's a small "time pgsql -f kill_all" output:
DELETE:
1) 0.03u 0.0
for the clearer understanding: this is NOT about TRUNCATE being
slow "as such" vs. DELETE, but about a change in the order of
a (...) magnitude from 7.3.4 to 7.4...
here's some more info, plus test results w/a "full" db:
300 tables, 2 pieces of modelled hw, so there's one table
w/2 entrie