On Sat, Oct 04, 2003 at 11:17:09PM -0400, Bruce Momjian wrote: > 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.
In this scenario, the VACUUM FULL-does-REINDEX idea would be the perfect fit because it will probably be much faster than doing indexbulkdelete. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Endurecerse, pero jamás perder la ternura" (E. Guevara) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org