From: | Jeff MacDonald <bignose(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Diskspace |
Date: | 2004-12-20 13:46:54 |
Message-ID: | f17daf04041220054656711c68@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2004-12-20 13:48:18 | Re: Diskspace |
Previous Message | Jeff MacDonald | 2004-12-20 13:39:15 | Diskspace |