Tom,
Le jeudi 1 Juillet 2004 19:22, Tom Lane a écrit :
> =?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.
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
