Hi All,
I have a couple of questions hopefully someone can help me with.
1) Does every relation exist in pg_class? Can we assume that if there is a file
with OID which is not present in pg_class, this file can be deleted? (we have a
few such files, some of them take more than 2G of space in to
Hi Tom,
Thanks for your reply.
I did mean the data/OIDs from the relfilenode column in pg_class.
Even when logged in as root, a 'ls -l' command returns:
mm2:/var/lib/pgsql82/data/base/16673 # ls -lash | more
/bin/ls: 19357877: Permission denied
/bin/ls: 19569529: Permission denied
/bin/ls: 1956
