Обсуждение: question about vacuum and index bloat
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
"John Lister" <john.lister-ps@kickstone.com> wrote: > 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? VACUUM makes space in indexes available for re-use. I don't think that reindex is normally needed for recent releases, although I seem to remember hearing that it was needed in older versions. What version are you running? -Kevin