Re: Unaccounted for disk use

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-novice by date

  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