At 12:04p -0400 on Tue, 12 Aug 2008, Joao Ferreira wrote: > I'm a bit lost here. I'm currently executing VACUUM FULL _and_ REINDEX > (tbls & idxs) every week. > > Should I keep the REINDEX and drop VACUUM FULL ? > > How do I iterate to a better approach ?
It might behoove you to read the Notes section of the docs about vacuuming: http://www.postgresql.org/docs/current/static/sql-vacuum.html Roughly, VACUUM simply reclaims/frees disk space, while VACUUM FULL additionally reorganizes disk usage. I'm still don't know *why* this leads to index bloat, however, just that it does. I must defer that explication to a Postgres guru. Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
