Re: oid2name reports much fewer files...

Sorry for the troubles, I was completly mistaken, oid2name needs the "-x"
parameter to view system tables,
and everything looks fine now. All numbers are ok now.

Thanks a lot!

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Mario Weilguni" <mweilguni@sime.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, August 13, 2002 6:33 PM
Subject: Re: [GENERAL] oid2name reports much fewer files...


> Mario Weilguni <mweilguni@sime.com> writes:
> > 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.
>
> The sequences should have files, so I make it 452 pg_class rows that
> should have corresponding files.  However, those rows that have
> relisshared = 't' correspond to files in $PGDATA/global, not files
> in your per-database directory.  In 7.2 I believe there should be ten
> such rows, one of which is pg_xactlock, so 443 seems the correct count.
>
> Could you make a list of the pg_class.relfilenode values for
> 'S','i','r','t' rows (excluding relisshared rows), and compare that
> against what oid2name is reporting to see what it is missing or
> getting wrong?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>