Thread: Which DB is using space.
Hi all, Below is the output from 'du -kx /|sort -rn|head'. It's showing that /var/lib/pgsql/data/base/46169 is using a big chunk of my disk. How can I tell which DB this is? What suggestions can people make to reduce the amount of disk space used by this DB? __BEGIN__ 361365 / 282030 /var 232427 /var/lib 186879 /var/lib/pgsql 186874 /var/lib/pgsql/data 153866 /var/lib/pgsql/data/base 122399 /var/lib/pgsql/data/base/46169 40675 /lib __END__ Ta -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
Gary Stainburn wrote: > Hi all, > > Below is the output from 'du -kx /|sort -rn|head'. It's showing that > /var/lib/pgsql/data/base/46169 is using a big chunk of my disk. > > How can I tell which DB this is? > What suggestions can people make to reduce the amount of disk space used by > this DB? > > __BEGIN__ > 361365 / > 282030 /var > 232427 /var/lib > 186879 /var/lib/pgsql > 186874 /var/lib/pgsql/data > 153866 /var/lib/pgsql/data/base > 122399 /var/lib/pgsql/data/base/46169 > 40675 /lib > __END__ > > Ta > -- > Gary Stainburn > > This email does not contain private or confidential material as it > may be snooped on by interested government parties for unknown > and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 Sure, see contrib/oid2name. It generates a list of oid/dbname pairs. Also, I recommend getting oid2name from the snapshot/CVS and using that. It has the newer readme and some changes to make the examples display properly. Also see the new doc section for 7.3 on disk usage: http://developer.postgresql.org/docs/postgres/diskusage.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
tradein_clients=# SELECT oid,datname from pg_database; oid | datname ----------+----------------- 27856881 | test 7865515 | sysstat 8990396 | access_log 16555 | template0 378968 | tradein_clients 378969 | rt2 1 | template1 (7 rows) also gives the same info. is it reliable? regds mallah. On Thursday 04 July 2002 18:55, Gary Stainburn wrote: > Hi all, > > Below is the output from 'du -kx /|sort -rn|head'. It's showing that > /var/lib/pgsql/data/base/46169 is using a big chunk of my disk. > > How can I tell which DB this is? > What suggestions can people make to reduce the amount of disk space used by > this DB? > > __BEGIN__ > 361365 / > 282030 /var > 232427 /var/lib > 186879 /var/lib/pgsql > 186874 /var/lib/pgsql/data > 153866 /var/lib/pgsql/data/base > 122399 /var/lib/pgsql/data/base/46169 > 40675 /lib > __END__ > > Ta -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.