470,848 Members | 1,653 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

oid file, but no pg_class row for it

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
1 2429
"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.

Similar topics

2 posts views Thread by matt | last post: by
reply views Thread by Jeff Boes | last post: by
1 post views Thread by Thomas Bamesberger | last post: by
reply views Thread by Tom Hebbron | last post: by
1 post views Thread by Gregory Stone | last post: by
8 posts views Thread by zhicheng wang | last post: by
7 posts views Thread by Randy Yates | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.