Unable to determine what has a particular OID

From: Andy Dale <andy(dot)dale(at)gmail(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Unable to determine what has a particular OID
Date: 2010-06-18 11:42:35
Message-ID: AANLkTimM4UGW6rwH07FApyDRfBJyXf-sw7pj1yPqfV9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We currently have a DB (8.3.7) in production that seem to be taking up more
space on the HDD than was anticipated.

After looking into the the data directory a particular file/oid is around 21
GB (the oid has 21 files), this OID can then be found in the pg_class table,
the explanation for the size being that the table has around 12.5 Million
rows. During the inspection of the data directory I observed another OID
that is around 8.5GB, but I cannot locate the corresponding entry in the
pg_class table (even after dumping the table into a file and grep-ing for
the OID in question).

Any other ideas for finding what the mystery OID is ?

Thanks in advance,

Andy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashesh Vashi 2010-06-18 12:40:41 Re: How to install 8.4 in Fedora 11 Leonidas
Previous Message Greg Smith 2010-06-18 11:29:23 Re: Backups / replication