From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Thoughts on maintaining 7.3 |
Date: | 2003-10-05 03:26:56 |
Message-ID: | 20031005032656.GC20484@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-05 03:53:49 | Re: Thoughts on maintaining 7.3 |
Previous Message | Lee Fesperman | 2003-10-05 03:23:55 | Re: Dreaming About Redesigning SQL |