Re: Freeze avoidance of very large table.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Freeze avoidance of very large table.
Дата
Msg-id CAA4eK1LuLhTeGid4Ef6N2zEZ-7Bh30qpJej2ne57sbvre53iUA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Freeze avoidance of very large table.  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Sat, Nov 14, 2015 at 1:12 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Tue, Nov  3, 2015 at 09:03:49AM +0530, Amit Kapila wrote:
> > I think in that case we can call it as page info map or page state map, but
> > I find retaining visibility map name in this case or for future (if we want to
> > add another bit) as confusing.  In-fact if you find "visibility and freeze
> > map",
> > as excessively long, then we can change it to "page info map" or "page state
> > map" now as well.
>
> Coming in late here, but the problem with "page info map" is that free
> space is also page info (how much free space on each page), so "page
> info map" isn't very descriptive.  "page status" or "page state" might
> make more sense, but even then, free space is a kind of page
> status/state.  What is happening is that broadening the name to cover
> both visibility and freeze state also encompasses free space.
>

Valid point, but I think free space map is a specific information of page
stored in a completely different format.  "page info"/"page state" map
could contain information about multiple states of page in same format.
There is yet another option of changing it Visibility and Freeze map and
or change file extension to vfm, but Robert felt that is rather long name
and I also agree with him.

Do you see retaining the visibility map as better option ?



With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Parallel Seq Scan
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Freeze avoidance of very large table.