Re: Reusing Dead Tuples:

Tom Lane wrote:<br /><blockquote cite="mid8875.1039581335@sss.pgh.pa.us" type="cite"><pre wrap="">Janardhan <a
class="moz-txt-link-rfc2396E"href="mailto:jana-reddy@mediaring.com.sg"><jana-reddy@mediaring.com.sg></a> writes:
</pre><blockquotetype="cite"><pre wrap="">Does it breaks anythings  by overwriting the dead tuples ?.
</pre></blockquote><prewrap="">
 
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
 </pre></blockquote> Does it breaks any other things if all the index entries pointing the dead tuple are  removed
beforereusing the dead tuple?.<br /><br /> Regards<br /> jana<br />