Robert Haas <robertmh...@gmail.com> writes: > One other thought: I'm wondering if we shouldn't try to push the work > of setting the all-visible bit into heap_page_prune().
Hm, maybe ... > But it seems to me that a page can't be all-visible unless there are > no dead line pointers and no HOT chains of length != 1, and > heap_prune_chain() does manage to call HeapTupleSatisfiesVacuum() for > every tuple, so the raw information seems like it is available without > any additional CLOG lookups. HeapTupleSatisfiesVacuum is interested in whether a dead tuple is dead to everybody, but I don't think it figures out whether a live tuple is live to everybody. On the assumption that most tuples are live, adding the latter calculation might represent significant expense. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers