Re: Thoughts on maintaining 7.3

On Sat, Oct 04, 2003 at 11:17:09PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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)