Thread: btree fast-root on VACUUM FULL
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)
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