From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Chris Cameron <chris(at)upnix(dot)com>, Pgsql-Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Unaccounted for disk use |
Date: | 2003-05-22 18:15:22 |
Message-ID: | 200305221115.22598.scrawford@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Start psql and run:
steve=# select oid,datname from pg_database;
1 | template1
16975 | template0
557126 | phones
557196 | steve
Those oids will relate to the directories in the database:
betelgeuse:/var/lib/pgsql/data/base # ls -l
drwx------ 2 postgres postgres 4096 May 16 10:09 1
drwx------ 2 postgres postgres 4096 May 15 17:15 16975
drwx------ 2 postgres postgres 4096 May 16 10:12 557126
drwx------ 2 postgres postgres 4096 May 22 10:42 557196
Then run:
select oid,relname from pg_class;
oid | relname
--------+---------------------------------
...
557249 | byteatest
557275 | projectcheck
...
Then switch to the appropriate database subdirectory and look for files with
the same name as the oids from pg_class. (Of course I have oversimplified a
bit in that you could have the same table name in multiple databases but it
will be pretty easy to distinguish as you will only find one of them in your
subdirectory.)
Cheers,
Steve
On Wednesday 21 May 2003 09:12, Chris Cameron wrote:
> 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Fontenot, Paul | 2003-05-22 19:12:16 | Re: How to send an email when data is inserted into a table |
Previous Message | Tom Lane | 2003-05-22 17:46:56 | Re: Problem on Linux |