Hello,
(Postgres 9.3.4/Linux)
we have about 15 % of the files in our tablespaces that are empty
and do not appear in "select pg_relation_filepath(oid) from pg_class".
My guess is that a lot of them are the result of vacuuming full around 50'000 tables out of 150'000.
Is there a known issue that can explain this ?
We have an unusual configuration where the tablespaces are located within $PGDATA,
either directly or as symbolic link...
- Is there a proof mean to identify all files that are still required
- A way to clean such zombies files ?
regards,
Marc Mamin