By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,692 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,692 IT Pros & Developers. It's quick & easy.

What are these files about?

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dmitry Tkach <dm****@openratings.com> writes:
But others for some reason cannot be matched... - there is no oid in
pg_class at all that would match the filename...


You should be looking at pg_class.relfilenode, not oid.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.