Re: Reusing Dead Tuples: - Mailing list pgsql-hackers

From Janardhan
Subject Re: Reusing Dead Tuples:
Date
Msg-id 3DF98A49.6080503@mediaring.com.sg
Whole thread Raw
In response to Re: Reusing Dead Tuples:  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reusing Dead Tuples:
List pgsql-hackers
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 /> 

pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Big 7.4 items
Next
From: Philip Warner
Date:
Subject: Re: Creating a zero-column table