Requesting clarification on Vacuuming/Freezing behaviour
От | Gokulakannan Somasundaram |
---|---|
Тема | Requesting clarification on Vacuuming/Freezing behaviour |
Дата | |
Msg-id | 9362e74e0712162347g65ef8165wbe5dc6fd514539ff@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Requesting clarification on Vacuuming/Freezing behaviour
|
Список | pgsql-hackers |
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>)
В списке pgsql-hackers по дате отправления: