Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group