On 18 June 2010 16:06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Andy Dale <andy.dale@xxxxxxxxx> writes:You should be looking at pg_class.relfilenode, not OID. See
> After looking into the the data directory a particular file/oid is around 21
> GB (the oid has 21 files), this OID can then be found in the pg_class table,
> the explanation for the size being that the table has around 12.5 Million
> rows. During the inspection of the data directory I observed another OID
> that is around 8.5GB, but I cannot locate the corresponding entry in the
> pg_class table (even after dumping the table into a file and grep-ing for
> the OID in question).
http://www.postgresql.org/docs/8.3/static/storage.html
regards, tom lane
Ok, but when I have dumped the pg_class table into a file like so:
-[ RECORD 1 ]--+----------------------------------------------------------------
relname | pg_type
relnamespace | 11
reltype | 71
relowner | 10
relam | 0
relfilenode | 1247
reltablespace | 0
relpages | 19
reltuples | 796
reltoastrelid | 0
reltoastidxid | 0
relhasindex | t
relisshared | f
relkind | r
relnatts | 26
relchecks | 0
reltriggers | 0
relukeys | 0
relfkeys | 0
relrefs | 0
relhasoids | t
relhaspkey | f
relhasrules | f
relhassubclass | f
relfrozenxid | 379
relacl | {=r/postgres}
reloptions |
-[ RECORD 2 ]--+----------------------------------------------------------------
relname | triggered_update_columns
relnamespace | 11313
reltype | 11477
relowner | 10
relam | 0
relfilenode | 11476
reltablespace | 0
relpages | 0
reltuples | 0
reltoastrelid | 0
Grep-ing for the correct oid/filenode (110660 in my case), nothing is returned.
Cheers,
Andy
