Re: Diskspace

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Jeff MacDonald <bignose(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Diskspace
Date: 2004-12-20 14:01:32
Message-ID: 20041220140132.GA26848@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 20, 2004 at 09:57:35AM -0400, Jeff MacDonald wrote:

> # select relname,relfilenode,relpages from pg_class where relfilenode
> = 13312279;
> relname | relfilenode | relpages
> -----------+-------------+----------
> email_log | 13312279 | 36821
>
> It just so happens that email_log has around 700,000 rows, that would
> explain the space issues.
>
> I do know that email_log is 100% deleteable, so I'll proceed with hosing that.
>
> Does all this sound reasonable ?

Certainly.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Para tener más hay que desear menos"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2004-12-20 14:05:31 Re: PG8 final when
Previous Message Jeff MacDonald 2004-12-20 13:57:35 Re: Diskspace