Re: oid2name reports much fewer files... - Mailing list pgsql-general

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?

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