[HACKERS] Index bloat and the need to REINDEX

2006-08-15 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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

Re: [HACKERS] Index bloat and the need to REINDEX

2006-08-15 Thread Alvaro Herrera
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.