| 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 |