Re: oid2name reports much fewer files...

OK, this is interesting. Seems your pg_class total is pretty close, but
oid2name isn't finding some of the pg_class entries.

We need to get that fixed first. Would you eyeball the pg_class list
against the oids and find one that isn't printing? Just grab one of the
oids that oid2name doesn't know about, and look it up in pg_class.

---------------------------------------------------------------------------

Mario Weilguni wrote:
> 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 list some files.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073