Re: Which DB is using space.

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.