Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > It would be nice if VACUUM FULL would be able to compress the actual > > index file and return unused space to the operating system. REINDEX > > does this, but I was thinking of something a little lighter that could > > be done automatically as part of VACUUM FULL. > > But indexes tend to be very dependent on physical layout. You can't > just shove stuff around without thinking about the consequences. > Tables (heaps) are *much* more forgiving about that. > > My feeling is that what we need to fix now is index bloat during normal > operation. If you want the indexes to actually *shrink*, that's a job > for REINDEX. Perhaps someday we can improve on that --- but let's not > blur our focus on the immediate problem.
My point is only that while we need VACUUM and VACUUM FULL to match all heap needs, we need a VACUUM FULL capability for indexes too. REINDEX may be that capability, but it would be nice if we could compress out some index space during VACUUM FULL. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
