Re: Yet another "drop table vs delete" question

Alvaro Herrera wrote:
> Try TRUNCATE.  That leaves the less garbage behind and takes the less
> time.

A follow up question, as far as I understand it, delete removes entries
in the fsm, so vacuum has to clean it all up when performing a delete,
is this approximately correct? what happens with truncate? does it
remove everything so that vacuum has almost no work to do or is it
approximately as much work either way?

regards

thomas