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
