Horton

Re: Thoughts on maintaining 7.3

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>, "Joshua D. Drake" <jd@commandprompt.com>, pgsql-hackers@postgresql.org
Date: 2003-10-05T03:17:09Z
Lists: pgsql-hackers 
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.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.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073