Re: oid2name reports much fewer files...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: oid2name reports much fewer files...
Date: 2002-08-13 15:12:45
Message-ID: 200208131512.g7DFCj606986@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Helge Bahmann 2002-08-13 15:19:31 Re: [HACKERS] Linux Largefile Support In Postgresql RPMS
Previous Message Tom Lane 2002-08-13 15:04:38 Re: [GENERAL] Linux Largefile Support In Postgresql RPMS