On Thu, Nov 20, 2008 at 9:03 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > > I don't think you can do that. Couldn't someone else have run > heap_page_prune between vacuum's first and second visit to the page? > > >
You mean the second visit in the first pass where we again check for HeapTupleSatisfiesVacuum ? We hold exclusive lock continuously in the first pass. So its not possible for someone else to call heap_page_prune. If its the second visit in the second heap scan, then it removes only the dead tuples recorded in the first pass. So we should be good there too. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com