"John Lister" <john.lister-ps@xxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
