dbTalk Databases Forums  

oid file, but no pg_class row for it

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss oid file, but no pg_class row for it in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ed L.
 
Posts: n/a

Default oid file, but no pg_class row for it - 11-03-2004 , 04:08 PM






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


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: oid file, but no pg_class row for it - 11-03-2004 , 04:56 PM






"Ed L." <pgsql (AT) bluepolka (DOT) net> writes:
Quote:
... 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.