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


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

"John Lister" <john.lister-ps [at] 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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin