Re: Pre-allocated free space for row

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Pre-allocated free space for row
Дата
Msg-id 8909.1125622296@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Pre-allocated free space for row  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I assume that for a vacuum that only hit pages indicated in the bitmap,
> it would still be necessary to do an index scan to remove the heap
> pointers in the index, right?

Given the current vacuum technology, yes.  However, bearing in mind that
indexes should generally be much smaller than their tables, cutting down
the table traversal is certainly the first-order problem.  (See also
discussion with Simon from today.)
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Pre-allocated free space for row
Следующее
От: Ricardo Humphreys
Дата:
Сообщение: Avoid using swap in a cluster