Thread: btree fast-root on VACUUM FULL

btree fast-root on VACUUM FULL

From
Alvaro Herrera
Date:
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)


Re: btree fast-root on VACUUM FULL

From
Tom Lane
Date:
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