If you are decommissioning the database, why not just rm -rf the whole system?
Your plan to loop over tables and truncate them seems great if you are worried. It seems simple to verify that space is being freed as you go, and also easy to change tactics if the need arises.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'