Hackers (especially Tom),

Would it be right to set the fast-root as true root during a VACUUM
FULL?  This would free all pages between true root and fast root.

(I'm not advocating to do it, nor volunteering; I'm merely wondering).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)

Fri, 11 Jul 2003 15:37:28 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
btree fast-root on VACUUM FULL
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Would it be right to set the fast-root as true root during a VACUUM
> FULL?  This would free all pages between true root and fast root.

Possibly okay, but why bother?  It's hardly likely to free a meaningful
number of pages.  And I think you'd need to invent another category of
WAL record to log the action, so the code overhead to make it happen
isn't trivial.

			regards, tom lane

Fri, 11 Jul 2003 20:32:55 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: btree fast-root on VACUUM FULL 