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