Re: Diskspace - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Diskspace
Date
Msg-id 20041220140132.GA26848@dcc.uchile.cl
Whole thread Raw
In response to Re: Diskspace  (Jeff MacDonald <bignose@gmail.com>)
Responses Re: Diskspace  (Jeff MacDonald <bignose@gmail.com>)
List 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[@]dcc.uchile.cl>)
"Para tener más hay que desear menos"

pgsql-general by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: Diskspace
Next
From: Együd Csaba (Freemail)
Date:
Subject: Re: PG8 final when