Which DB is using space.

Поиск
Список
Период
Сортировка
Искать

Which DB is using space.

От:
Gary Stainburn <gary.stainburn@ringways.co.uk>
Дата:
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     



Re: Which DB is using space.

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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


Re: Which DB is using space.

От:
"Rajesh Kumar Mallah." <mallah@trade-india.com>
Дата:
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.




FAQ