Greg Sabino Mullane wrote:

> Is there a better solution to the "index bloat" problem with regards
> to minimizing locking while reducing an ever-growing use of disk
> space? In particular, it would be nice if there was a way to force
> VACUUM [FULL] to do some of the compression that REINDEX now does.
> Right now, we have tables that are updated very frequently, and a
> vacuum full just doesn't do much to reduce the disk space, as
> the indexes keep growing until a REINDEX is done. Tried on HEAD
> as well.

Vacuum full doesn't do anything to shrink the indexes -- rather, it's
the other way around, they become more bloated.  Your best bet is to
vacuum (not full) very frequently.

Alvaro Herrera                      
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to