On Sat, 1 Dec 2001, Tom Lane wrote:
> Ken Corey <ken.corey@atomic-interactive.com> writes:
> > Several of my tables are being emptied and totally replaced (statistics about
> > how my website is running, that sort of thing). Is it better to drop the
> > table, and rebuild it in this case?
>
> Consider TRUNCATE.
Does truncate releases all the space from the indexes?
> I suspect if you look at the stats (see pg_class.relpages) you'll find
> that the space VACUUM fails to reclaim is in indexes.
Does it mean that if records are deleted an one does vacuum, that index
space may not be released?