Diskspace

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