<br /><br /><div class="gmail_quote">On Thu, Nov 20, 2008 at 9:03 PM, Tom Lane <span dir="ltr"><<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br
/></div>Idon't think you can do that. Couldn't someone else have run<br /> heap_page_prune between vacuum's first and
secondvisit to the page?<br /><br /> <br /></blockquote></div><br />You mean the second visit in the first pass where
weagain check for HeapTupleSatisfiesVacuum ? We hold exclusive lock continuously in the first pass. So its not possible
forsomeone else to call heap_page_prune. If its the second visit in the second heap scan, then it removes only the
deadtuples recorded in the first pass. So we should be good there too.<br /><br />Thanks,<br />Pavan<br clear="all"
/><br/>-- <br />Pavan Deolasee<br />EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br/>