Postgres Pro
Downloads
Home   >   mailing lists

Re: DELETE TABLE xx do not erase index file after a vacuum full ? - Mailing list pgsql-general

From Tom Lane
Subject Re: DELETE TABLE xx do not erase index file after a vacuum full ?
Date
Msg-id 28656.1088702575@sss.pgh.pa.us
Whole thread Raw
In response to DELETE TABLE xx do not erase index file after a vacuum full ?  (Hervé Piedvache <herve@elma.fr>)
Responses Re: DELETE TABLE xx do not erase index file after a vacuum full ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-general
Tree view 
=?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

pgsql-general by date:

Previous
From: Bill Montgomery
Date:
Subject: Re: backups
Next
From: Tom Lane
Date:
Subject: Re: Problems restarting after database crashed (signal 11).