Re: [HACKERS] Buglist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Buglist
Дата
Msg-id 11335.1061563550@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Buglist  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: [HACKERS] Buglist  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: [HACKERS] Buglist  (Jan Wieck <JanWieck@Yahoo.com>)
Re: [HACKERS] Buglist  ("Matthew T. O'Connor" <matthew@zeut.net>)
Re: [HACKERS] Buglist  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-general
Jan Wieck <JanWieck@Yahoo.com> writes:
> Shridhar Daithankar wrote:
>> Umm.. What does FSM does then? I was under impression that FSM stores page
>> pointers and vacuum work on FSM information only. In that case, it wouldn't
>> have to waste time to find out which pages to clean.

> It's the other way around! VACUUM scan's the tables to find and reclaim
> free space and remembers that free space in the FSM.

Right.  One big question mark in my mind about these "partial vacuum"
proposals is whether they'd still allow adequate FSM information to be
maintained.  If VACUUM isn't looking at most of the pages, there's no
very good way to acquire info about where there's free space.

            regards, tom lane

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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Buglist
Следующее
От:
Дата:
Сообщение: Re: pg_dump and alter database