Which DB is using space.

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема Which DB is using space.
Дата
Msg-id 200207041425.14911.gary.stainburn@ringways.co.uk
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Florian Helmberger"
Дата:
Сообщение: Re: starting the databaseserver
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Union strange explain