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.
[ Parent
| on HN ]
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.
Uh, indexes in postgres point to the tuple, not the page.
Except for BRIN.