Mime-Version: 1.0 (Apple Message framework v622)
In-Reply-To: <20050421204618.GD19744@dcc.uchile.cl>
References: <6f4567d4e64297b356e2d71ec392cdae@richardplotkin.com>
	<4574.1114030270@sss.pgh.pa.us>
	<b155378a669f04e74f597d4b105c2a10@richardplotkin.com>
	<062f2ea825779496716ce4e72b02e62f@richardplotkin.com>
	<20050421204618.GD19744@dcc.uchile.cl>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <25f772179a36fcacc7ac4169350d4781@richardplotkin.com>
Content-Transfer-Encoding: 7bit
From: Richard Plotkin <richard@richardplotkin.com>
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
Date: Thu, 21 Apr 2005 14:01:36 -0700
To: pgsql-performance@postgresql.org

That returned the same result.  I also tried oid2name -d smt -x -i -S 
and, separately -s, and also separately, -d with all other databases, 
and none of the databases turned up any listing, in either oid or 
filenode, for any of these three bloated files.  One thing I've noticed 
is that these oids are all extremely large numbers, whereas the rest of 
the oids in /data/base/* are no higher than 40000 or 50000.

On Apr 21, 2005, at 1:46 PM, Alvaro Herrera wrote:

> On Thu, Apr 21, 2005 at 11:38:22AM -0700, Richard Plotkin wrote:
>> More info on what is bloating:
>>
>> It's only in one database (the one that's most used), and after 
>> running
>> oid2name on the bloated files, the result is (mysteriously) empty.
>> Here's the run on the three enormous files:
>>
>> $ /usr/local/bin/oid2name -d smt -o 160779
>> From database "smt":
>>   Filenode  Table Name
>> ----------------------
>
> Try -f instead of -o ...
>
> -- 
> Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
> "World domination is proceeding according to plan"        (Andrew 
> Morton)
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>