Hi, excuse my ignorance, but I have a couple of quick questions regarding
vacuuming and indexes.
When you do a vacuum it marks the deleted rows as being usable again and I
can see that it reports that "xxx index row versions were removed", however
are these rows marked for reuse in an index in the same manner as they are
in the table? I note that the docs say that vacuum full doesn't shrink
indexes and that a reindex is recommended periodically, is this still true
if the table is frequently vacuumed?
Thanks
John
