Re: Reusing Dead Tuples:

Tom Lane wrote:

>Janardhan <jana-reddy(at)mediaring(dot)com(dot)sg> 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