I have some file in my database directories that I can not find an purpose to.
What I have been doing is trying to relate each file in my <db
path>/base/<oid>/ to the actual name (ie tablea, indexb,
etc...), and I have ran into files that are not in the pg_class
table. I am not sure where else to look for the purpose of these
files. Can anyone give me some suggestions? Files appear to
be oids in name, and some of them are split into multiple files
(i.e.2109357800, 2109357800.1, 2109357800.2, 2109357800.3,
2109357800.4).
Thanks for any help,
Chris
PG 7.3.4