Re: Disk filling, CPU filling, renegade inserts and deletes?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Richard Plotkin <richard(at)richardplotkin(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
Date: 2005-04-21 20:46:18
Message-ID: 20050421204618.GD19744@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"World domination is proceeding according to plan" (Andrew Morton)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Plotkin 2005-04-21 21:01:36 Re: Disk filling, CPU filling, renegade inserts and deletes?
Previous Message Litao Wu 2005-04-21 20:39:27 Re: index not used