Hey Julien,
thanks for the original query !
There was a slight mistake in the query,
it was comparing the file name with
pg_class.relfilenode.
It is not safe in some case (see doc : "caution"
in here)
, so better use the pg_relation_filenode() function.
AS a result this database could not be started anymore (no worry I had copy).
However using pg_relation_filenode() seems to be safe (passes vacuum full analyse).
I'll modify the query as soon as I have access to gist.
I agree the warning about tablespace is also important.
I'll put all of this on the wiki as soon has I have permission to create a new page
(man, how long is this "cool-off", it's been already several days !).
Cheers,
Rémi-C