Re: oid2name reports much fewer files...

Am Dienstag, 13. August 2002 17:12 schrieb Bruce Momjian:
> Mario Weilguni wrote:
> > For a specific db, oid2name reports 303 objects, and I've 430
> > files lying around. only the pg_largeobject table is greater
> > than 1 GB, and so has 2 files. But I've no idea what the other
> > files might be. The files in question occupy around 200MB, so
> > I'm curious what these files might be.
>
> Wow, that is a good question.  I sure hope it isn't cruft left over from
> crashes.  What modification dates do the files have?  What version of
> PostgreSQL are you using?

It's version 7.2.1.
I'm not aware of any crashes, everything works fine (except the problem "no one parent tuple found" as mentiond on
pgsql-hackers)

I checked it again, it are exactly 301 files from oid2names (2 were header).

This info is from the database itself:
cms=# SELECT count(1) from pg_class ;
 count
-------
   476
(1 row)

cms=# SELECT count(1), relkind from pg_class group by relkind;
 count | relkind
-------+---------
     7 | S
   299 | i
   103 | r
     1 | s
    43 | t
    23 | v


And there are 443 files in the directory (without pg_internal.init, pgsql_tmp, PG_VERSION, and one pg_largeobject file
16404.1)

Lets see:
476 entries - 23 views - 1 pg_xactlock - 7 sequences makes 445 entities, still off by 2. But it seems oid2name does not
listsome files.