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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
