Re: Dead Space Map

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dead Space Map
Дата
Msg-id 16717.1141149708@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Dead Space Map  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Heikki Linnakangas wrote:
>> Index tuples have commit info hint bits in them, don't they? You would 
>> still have to update those.

> Right, but consider that we would have to use the index to find the
> matching reusable heap to begin with, so we could clear the hint bit.

Not that easy: there's a race condition, ie, someone who's just visited
the dead tuple might be on their way back to the index to set the hint
bit.

Have we killed this idea sufficiently dead yet?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dead Space Map
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] temporary indexes