Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Do we move empty index pages to the end before truncation during vacuum > > full? > > No. You'd be better off using REINDEX for that, I think. IIRC we have > speculated about making VAC FULL fix the indexes via REINDEX rather than > indexbulkdelete.
I guess my point is that if you forget to run regular vacuum for a month, then realize the problem, you can just do a VACUUM FULL and the heap is back to a perfect state as if you had been running regular vacuum all along. That is not true of indexes. It would be nice if it would. -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
