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-04T03:36:57Z
Lists: pgsql-hackers 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Though the new code will put empty index pages into the free-space map,
> will it also shrink the index file to remove those pages?

If there are free pages at the end, yes --- but it won't move pages
around.  This is about the same story as for plain VACUUM ...

			regards, tom lane