Re: Unaccounted for disk use - Mailing list pgsql-novice

From Chris Cameron
Subject Re: Unaccounted for disk use
Date
Msg-id 1053533522.1645.13.camel@localhost
Whole thread Raw
In response to Re: Unaccounted for disk use  ("Paul Fontenot" <paul@evtr.org>)
Responses Re: Unaccounted for disk use
Re: Unaccounted for disk use
List pgsql-novice
I've tried:

vacuumdb -f -U postgres dbname
vacuumdb -a -f -z -U postgres


As suggested in another email, I've been looking around to see where
this space was getting used.

[root@ilearner base]# pwd
/var/lib/pgsql/data/base
[root@ilearner base]# du -hs *
3.5M    1
3.6M    16975
103M    16976
[root@ilearner base]# cd 16976
[root@ilearner 16976]# du -hs * | grep M
26M     1456419
6.1M    1456422
35M     639251
30M     639253
[root@ilearner 16976]#


So, that means nothing to me, hopefully it helps someone else though.


Thanks,
Chris

On Tue, 2003-05-20 at 21:27, Paul Fontenot wrote:
> did you do vacuum full? Or just a vacuum?

--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
bitbucket.upnix.net
--
http://www.upnix.com


pgsql-novice by date:

Previous
From: Renê Salomão
Date:
Subject: Installing PlPerl
Next
From: Tom Lane
Date:
Subject: Re: Unaccounted for disk use