What are these files about?

Dmitry Tkach

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

Subscribe Post Reply

1251

Tom Lane

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

by: Brandon J. Van Every | last post by:

I'm realizing I didn't frame my question well. What's ***TOTALLY COMPELLING*** about Ruby over Python? What makes you jump up in your chair and scream "Wow! Ruby has *that*? That is SO...

Python

699

Python syntax in Lisp and Scheme

by: mike420 | last post by:

I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...

Python

What I want in an editor/IDE

by: Chris Cioffi | last post by:

I started writing this list because I wanted to have definite points to base a comparison on and as the starting point of writing something myself. After looking around, I think it would be a...

Python

rotor replacement

by: Reed L. O'Brien | last post by:

I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption?...

Python

What, exactly, is ASP?

by: Peter Morris | last post by:

What, exactly, is ASP? Is ANY dynamically generated HTML the same as ASP? Or does ASP have to be in a particular format or language? The company I used to work for (until it went bust) was in...

ASP / Active Server Pages

125

What so special about PostgreSQL and other RDBMS?

by: Sarah Tanembaum | last post by:

Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...

Microsoft SQL Server

121

What IDE are you using?

by: typingcat | last post by:

First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...

PHP

What's wrong with my lex and yacc program?

by: cylin | last post by:

Dear all, I am a newbie using lex and yacc. I really don't know what's wrong with my code, because the output is not what I want. My yacc rules don't match, and yylex seems just read only one...

C / C++

What is the equivalent of DLL in a Unix environment??

by: Alan | last post by:

Is anyone know the equivalent term used for Dynamic Link Library (DLL) in unix environment?? Thanks Alan

C / C++

Article: What is Isolated Storage ? (.Net FrameWork Tools Series)

by: Namratha Shah $Nasha$ | last post by:

Hey Group, After a long week end I am back again. Its nice and refreshing after a short vacation so lets get started with .NET once again. Today we will discuss about Isolated Storage. This is...

.NET Framework

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics