Re:The State of Vacuum in Postgres
by anarazel on Friday January 05, 2018 @06:00PM
(#16082551)
> Seems kind of a bad design to rely on periodic full data scans.
Note that it's not full scans - only pages that have been modified since the last vacuum, or were in a state last vacuum that they couldn't be processed, are vacuumed again. So there essentially is a block-level index for this.
Note that it's not full scans - only pages that have been modified since the last vacuum, or were in a state last vacuum that they couldn't be processed, are vacuumed again. So there essentially is a block-level index for this.
https://www.postgresql.org/docs/current/static/storage-vm.ht...