Re: [HACKERS] Reusing Dead Tuples:

[Janardhan]

Tom Lane wrote:

Janardhan <[EMAIL PROTECTED]> writes:
  

Does it breaks anythings  by overwriting the dead tuples ?.
    

Yes.  You cannot do that unless you've first removed index entries
pointing at the dead tuples --- and jumped through the same locking
hoops that lazy vacuum does while removing index entries.

			regards, tom lane

  

if i am not wrong while  updating a tuple, we are also creating a  new index entry . so  if the
tuple is dead then the index entry pointing it also a dead index tuple. so even if dead index tuple is not
removed then also it should not break thing, since the dead index tuple will not be used, am i correct?.

what is reason why the dead heap tuples are maintained in a linked list ?. since for every dead heap tuple there
is a corresponding dead index tuple.

Regards
jana