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

Tom,

Le jeudi 1 Juillet 2004 19:22, Tom Lane a écrit :
> =?iso-8859-15?q?Herv=E9_Piedvache?= <herve(at)elma(dot)fr> writes:
> > I have done a :
> > DELETE from my_table;
>
> TRUNCATE would serve you a lot better.

Impossible for this table because it's used by another table with a
referential integrity ... so truncate is refused ...

> 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.
>

OK Thanks REINDEX is perfect ! ;o)

regards,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902