Why do index access methods use LP_DELETE? - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Why do index access methods use LP_DELETE?
Date
Msg-id 20050812101313.46F1.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
Whole thread Raw
Responses Re: Why do index access methods use LP_DELETE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: data on devel code perf dip
Next
From: Bruce Momjian
Date:
Subject: Re: data on devel code perf dip