balajij8
Contributor III

VACUUM will never delete files on the latest version even if Version 10 was not accessed or modified as it represents the current state of the table. VACUUM targets files that are not referenced by the recent version. It identifies files that were removed (due to DELETE/UPDATE etc in Versions 0 - 9) and if those specific files are not part of Version 10 and their deletion timestamp in the Log is older than the 7 day retention threshold, they are permanently deleted.

View solution in original post