Why do index access methods use LP_DELETE?

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Why do index access methods use LP_DELETE?
Дата
Msg-id 20050812101313.46F1.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
обсуждение исходный текст
Ответы Re: Why do index access methods use LP_DELETE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi Hackers,

I found index access methods use LP_DELETE for invisible tuples,
but it seems to be ok to remove LP_USED instead of adding LP_DELETE.

I tried the following simple replacements: - '|= LP_DELETE' => '&= ~LP_USED' - 'ItemIdDeleted' => '!ItemIdIsUsed'
and then, it passed all regression tests.

Why do index access methods use LP_DELETE?
Does this change make troubles?


(However, I guess there is no advantage in the change,because unused items are not recycled until next vacuum.)

---
ITAGAKI Takahiro
NTT Cyber Space Laboratories



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: data on devel code perf dip
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: data on devel code perf dip