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(at)dcc(dot)uchile(dot)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[(at)]dcc(dot)uchile(dot)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