>>>Bruce Momjian said: > > This brings up one item it would be nice to address at the same time. > It would be nice if VACUUM FULL would be able to compress the actual > index file and return unused space to the operating system. REINDEX > does this, but I was thinking of something a little lighter that could > be done automatically as part of VACUUM FULL. If we can do that, it > would make consistent behavior for vacuum and heap/index files.
Since lazy VACUUM exists, I always wondered why VACUUM FULL doesn't run REINDEX on a table where significant number of deleted tuples. VACUUM knows those numbers - I always run REINDEX on larger tables that had huge number of index entries deleted during VACUUM... Daniel ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
