Hi Experts,
Background - PG version 9.4
Running in Linux Rhel
We have a scenario where we ran Vacuum Full (2 TB Table)but due to some reason Vacuum Full failed.
These have let almost 1 TB orphan Relfilenodes inside base directory under the concern database which does not map with pg_class.
For example - Select * from pg_class where relfilenode = 123456. It does not return any row but those relfilenode exist inside base.
It would be great if you can suggest how to remove those orphan files. I know definitely manually deleting is not suggested so thought to know your suggestions.
Kind Regards,
Rahul Saha