By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

oid file, but no pg_class row for it

P: n/a
While dealing with filesystem bloat issues, I found a large file
named 43710738, recently updated and sitting in one of my
database directories,

$ ls -lh ../../../data/base/11259315/43710738
-rw------- 1 dba dba 1016M Nov 3 17:05 ../../../data/base/11259315/43710738

.... with no corresponding entry that I can find in pg_class with
that oid (I thought they were all in there). I tried dumping the
database, knowing the oids are in the comments, but found
nothing there. pg_filedump'ing the file doesn't seem to be
helpful, either.

Anyone have any tips on how to figure out what this oid maps to?

TIA.

Ed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Ed L." <pg***@bluepolka.net> writes:
... with no corresponding entry that I can find in pg_class with
that oid (I thought they were all in there).


Look at relfilenode, not OID.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.