Re: Diskspace

pg_class tells me

select relname,relfilenode,relpages from pg_class  where relfilenode = 13312283;
      relname      | relfilenode | relpages
-------------------+-------------+----------
 pg_toast_13312279 |    13312283 |   367639

So now I guess I have to find out what 13312279 is..

Ah HA !

# 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 ?

Jeff.

On Mon, 20 Dec 2004 10:51:32 -0300, Alvaro Herrera
<alvherre@dcc.uchile.cl> wrote:
> On Mon, Dec 20, 2004 at 09:48:57AM -0400, Jeff MacDonald wrote:
> > I'm using 7.3.4
>
> And what about pg_class?
>
> --
> Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
> "Industry suffers from the managerial dogma that for the sake of stability
> and continuity, the company should be independent of the competence of
> individual employees."                                      (E. Dijkstra)
>


--
Jeff MacDonald
http://www.halifaxbudolife.ca