Re: btree fast-root on VACUUM FULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: btree fast-root on VACUUM FULL
Дата
Msg-id 14234.1057969975@sss.pgh.pa.us
обсуждение исходный текст
Ответ на btree fast-root on VACUUM FULL  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: btree fast-root on VACUUM FULL
Следующее
От: "Francisco Figueiredo Jr."
Дата:
Сообщение: Re: Transaction handling in extended query mode and Sync