determining database size

Поиск
Список
Период
Сортировка
От Lee Kindness
Тема determining database size
Дата
Msg-id 15550.31193.891286.188798@kelvin.csl.co.uk
обсуждение исходный текст
Ответ на determining database size  (Jeff Davis <list-pgsql-general@dynworks.com>)
Список pgsql-general
Take a look at dbsize in the contrib directory of the source
distribution - it's a function you add to your DB to get the size of
databases. I don't know how the RPMs handle the contrib stuff, but it
might be available without compiling it yourself.

Nicer than the other ways...

Jeff Davis writes:
 > I would just like to know how to determine the size of a database. The
 > directories inside the data directory are numerical, so I can't associate
 > them with a particular database or table.
 >
 > I would basically just like to create reports so I can determine how fast the
 > disk usage is increasing.

В списке pgsql-general по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: Questions on 7.2.1 query plan choices
Следующее
От: Petr Bravenec
Дата:
Сообщение: Re: SQL question..