Re: Reg: Query for DB growth size

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Reg: Query for DB growth size
Дата
Msg-id 20181129090635.GG9004@paquier.xyz
обсуждение исходный текст
Ответ на Re: Reg: Query for DB growth size  ("R.R. PRAVEEN RAJA" <rrpraveenraja@live.com>)
Список pgsql-general
On Thu, Nov 29, 2018 at 08:15:10AM +0000, R.R. PRAVEEN RAJA wrote:
> I hope you did not understand my question. I am not asking query for
> current database size. I am asking for database growth, i mean
> predicting the increase in database size over a period like a month
> just like its available in oracle.

Why not running a cron job which stores periodically the result of
pg_database_size with a timestamp (simply now())?  Then you have as much
data as you want for growth comparison.
--
Michael

Вложения

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Reg: Query for DB growth size
Следующее
От: Condor
Дата:
Сообщение: Re: Reg: Query for DB growth size