| From: | Chris Cameron <chris(at)upnix(dot)com> | 
|---|---|
| To: | Pgsql-Novice <pgsql-novice(at)postgresql(dot)org> | 
| Subject: | Re: Unaccounted for disk use | 
| Date: | 2003-05-21 16:12:02 | 
| Message-ID: | 1053533522.1645.13.camel@localhost | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(at)ilearner base]# pwd
/var/lib/pgsql/data/base
[root(at)ilearner base]# du -hs *
3.5M    1
3.6M    16975
103M    16976
[root(at)ilearner base]# cd 16976
[root(at)ilearner 16976]# du -hs * | grep M
26M     1456419
6.1M    1456422
35M     639251
30M     639253
[root(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Renê Salomão | 2003-05-21 16:26:35 | Installing PlPerl | 
| Previous Message | Joe Conway | 2003-05-21 15:32:57 | Re: parse error when executing a simple plpgsql function |