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.
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.
pgsql-general by date
|Next:||From: Jeff MacDonald||Date: 2004-12-20 13:46:54|
|Subject: Re: Diskspace|
|Previous:||From: Russ Brown||Date: 2004-12-20 13:32:57|
|Subject: Re: PG8 final when|