> 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

> 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.html https://www.postgresql.org/docs/current/static/storage-vm.ht...