Re: Automatic free space map filling

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: Automatic free space map filling
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579D98D6E@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Automatic free space map filling  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Automatic free space map filling  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
> > But you could do the indexes first and remember how far you
> can vacuum
> > the heap later.
>
> But the indexes _can't_ be done first; you _first_ need to
> know which tuples are dead, which requires looking at the
> table itself.

If we already had the "all tuples visible" bitmap I think we could
first scan the bitmap and decide whether we can afford to look
at the visibility info for each entry in the index.

We only collect the ctids before so we don't have the inefficient
lookups,
but if we can avoid the lookup in most cases it would again be
attractive.

Andreas


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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: [PATCHES] LDAP auth
Следующее
От: Q Beukes
Дата:
Сообщение: Real Life Data