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
