Which DB is using space. - Mailing list pgsql-admin

From Gary Stainburn
Subject Which DB is using space.
Date
Msg-id 200207041425.14911.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: Which DB is using space.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Which DB is using space.  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: "Florian Helmberger"
Date:
Subject: Re: starting the databaseserver
Next
From: "Gaetano Mendola"
Date:
Subject: Union strange explain