I'm getting an error for around half of my tables in Postgres while trying to run VACUUM FULL.
For example, I have a table named 'qwerty', and when i try to vacuum it i get the following error:
ERROR: could not fsync file "base/16392/3655838": Input/output error
But for some reason, when i run:
It shows the file path as another:
I cant seem to find any information about this online, I would be more than glad if anybody could help!