Skip site navigation (1) Skip section navigation (2)

Diskspace

From: Jeff MacDonald <bignose(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Diskspace
Date: 2004-12-20 13:39:15
Message-ID: f17daf0404122005391ffddf01@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Jeff MacDonaldDate: 2004-12-20 13:46:54
Subject: Re: Diskspace
Previous:From: Russ BrownDate: 2004-12-20 13:32:57
Subject: Re: PG8 final when

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group