On Thu, Nov 20, 2008 at 9:03 PM, Tom Lane
<tgl@sss.pgh.pa.us> 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
