Horton

Re: Thoughts on maintaining 7.3

Tom Lane <tgl@sss.pgh.pa.us>

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

			regards, tom lane