What are these files about?

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: pg_general <pgsql-general(at)postgresql(dot)org>
Subject: What are these files about?
Date: 2003-11-14 23:00:22
Message-ID: 3FB55E86.3070601@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, everybody!

I have been running a 7.3 database for a couple of weeks... and it has
grown by more than 20Gig on me within that interval...
I have a copy of the original database (I just copied all the files
before I started using it), and am trying to find out what exactly it is
that grew so much...

My understanding is that the files are identified by the oids the
objects they belong to...
I have no problem locating some of those objects in pg_class table and
matching them to my tables and indices...

But others for some reason cannot be matched... - there is no oid in
pg_class at all that would match the filename...
I am wonderring if somebody could please let me know what are these
unmatched files and how I can locate the actual objects that are using them?

Thank you very much!

Dima

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dustin Sallings 2003-11-14 23:15:09 Re: embedded postgresql
Previous Message Joseph 2003-11-14 22:53:29 Help with quote escaping in plpgsql