Re: DELETE TABLE xx do not erase index file after a vacuum full ?

=?iso-8859-15?q?Herv=E9_Piedvache?= <herve@elma.fr> writes:
> I have done a :
> DELETE from my_table;

TRUNCATE would serve you a lot better.

For major reductions in table size VACUUM FULL is not the best tool;
you really want to reconstruct the indexes from scratch.  Consider
REINDEX, CLUSTER, or (in this case) TRUNCATE.

            regards, tom lane