Re: Diskspace

Hi,

We after some more reading I learned that this huge file is my TOAST table..

Is there a way to schrink that down ?

Thanks.

Jeff.


On Mon, 20 Dec 2004 09:39:15 -0400, Jeff MacDonald <bignose@gmail.com> wrote:
> Hi,
>
> I have a database that is about 3.5 gigs big. And I have a pretty
> serious hunch that there isn't that much data.
>
> I did a "du -s *|sort -n " in /usr/local/pgsql/data/base/9039913
>
> And got a list that ends with these entries.
>
> 55648   18070582
> 137296  13312252
> 294736  13312279
> 845648  13312283.2
> 1049104 13312283
> 1049104 13312283.1
>
> There are pleanty of other tables, but these are teh big ones.
>
> So I tried this
>
> select * from pg_statio_user_tables where relid = 13312283;
>
> and got no row returned, when i did
>
> select * from pg_statio_user_tables where relid = 13312279;
>
> i told me which table i was looking for.
>
> So I guess my question is, how do i find out what 13312283.* are, are
> they safe to delete ?
>
> Will a dump/reload fix things up ? I'm trying a vacuum now, as well i
> checked the queries in pg_statio_all_tables too.
>
> Thanks.
>
> --
> Jeff MacDonald
> http://www.halifaxbudolife.ca
>


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