Skip site navigation (1) Skip section navigation (2)

size difference between du and PG_CLASS

From: "Lee Wu" <Lwu(at)mxlogic(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: size difference between du and PG_CLASS
Date: 2004-06-22 15:47:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi All,


We have a big difference between du and PG_CLASS:


du -hs ./base/17613

21G     ./base/17613


select sum(relpages)*8/1024/1024 from pg_class;




(1 row)


I am sure I run the select under the right database (17613).


I know there are some files under:

du -hs base/17613/pgsql_tmp

1.7G    base/17613/pgsql_tmp


But the difference is still around 8G (21G - 11G - 1.7G). 


When I check timestamp on files under directory 17613, I found there are
many old relfilenode which do not exist 

in the pg_class any more. We had bounced the PG server, those files are
still there.


Does PG remove those files which are not longer used by PG after server


Which files can I safely delete?




PS: PG version 7.3.2 and OS version Red Hat Linux release 7.3 (Valhalla)


pgsql-admin by date

Next:From: Michael HoldenDate: 2004-06-22 17:09:42
Subject: phpmyadmin type thing for postgre?
Previous:From: juanmimeDate: 2004-06-22 14:32:18
Subject: Problems restoring a DB with oids

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group