News for hackers. Stuff that matters.
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.

https://www.postgresql.org/docs/current/static/storage-vm.ht...

There are no comments on this comment yet.