Re: Disk filling, CPU filling, renegade inserts and deletes? - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Disk filling, CPU filling, renegade inserts and deletes?
Date
Msg-id 20050421204618.GD19744@dcc.uchile.cl
Whole thread Raw
In response to Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin <richard@richardplotkin.com>)
Responses Re: Disk filling, CPU filling, renegade inserts and deletes?
List pgsql-performance
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)

pgsql-performance by date:

Previous
From: Litao Wu
Date:
Subject: Re: index not used
Next
From: Richard Plotkin
Date:
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?