News for hackers. Stuff that matters.
Re:The State of Vacuum in Postgres by devit on Friday January 05, 2018 @05:56PM (#16082514)
It's just an index on the transaction id fields of the rows, so it should scale like any other index on the table.
Re:The State of Vacuum in Postgres by rosser on Friday January 05, 2018 @06:07PM (#16082581)
So, basically the already-existing Visibility Map?

Indexes in postgres point to the page, not the tuple. The VM keeps two bits per page: "does this page have any 'dead' tuples?", and "does this page need to be touched for xid wraparound?"

Vacuuming doesn't touch a page unless the VM indicates it's necessary.

Re:The State of Vacuum in Postgres by rhaas on Saturday January 06, 2018 @10:33AM (#16085644)
Uh, indexes in postgres point to the tuple, not the page.

Except for BRIN.

Re:The State of Vacuum in Postgres by rosser on Saturday January 06, 2018 @04:38PM (#16087603)
Thanks for the correction, Robert! Now I'm curious where I got that notion.