Michael J Davis wrote:
> Maybe vacuum should be changed to automatically drop all indexes, vacuum,
> and re-create all indexes and stop trying to rebuild each index.
Those were my thoughts, but I think there may be a problem in that the indexes
will get lost if vacuum crashes before restoring the indexes. That is pretty
undesirable. Also, if there are relatively few updates to a large table
building a new index is going to take longer than the vacuum, which is actually
relatively quick if done regularly. Dunno what the best solution is.
I think it will be very hard to do away with vacuum completely: one may be able
to reuse space, but with variable length records there is always going to be
some fragmentation. Of course vacuumes may become less important if some space
can be reused?
Adriaan