Re: btree fast-root on VACUUM FULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: btree fast-root on VACUUM FULL
Date: 2003-07-12 00:32:55
Message-ID: 14234.1057969975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2003-07-12 01:10:05 Re: Transaction handling in extended query mode and Sync
Previous Message Maksim Likharev 2003-07-11 23:12:30 Re: PG crash on simple query, story continues