Hi,<br /> I got some time to relook at the index with the snapshot patch. Still i need to complete the freezing of
indextuples with the snapshot.<br />a) When i was looking at the code for freezing heap tuples, i found out the
following.While freezing we log the complete block(not just the tuples we froze). <br />b) Again after removing the
deadtuples and fragmentation, we log the complete block.<br /><br />As i understand, Vacuum is one atomic operation.
Whydo we need to make this extra protection for Freezing?<br />I think the fix should be very simple. Before logging
theFrozen block, we need to check whether there are any dead tuples removed from it.. <br /><br />Please clarify on
whetheri am missing something important..<br clear="all" /><br />-- <br />Thanks,<br />Gokul.<br />CertoSQL Project,<br
/>AlliedSolution Group.<br />(<a href="http://www.alliedgroups.com">www.alliedgroups.com </a>)