From: Richard Plotkin <richard@richardplotkin.com>
To: pgsql-performance@postgresql.org
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
Date: Thu, 21 Apr 2005 14:01:36 -0700
Message-ID: <25f772179a36fcacc7ac4169350d4781@richardplotkin.com> (raw)
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>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: richard@richardplotkin.com
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
In-Reply-To: <25f772179a36fcacc7ac4169350d4781@richardplotkin.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox