Обсуждение: Database size on disk

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

Database size on disk

От
"Quiroga, Damian"
Дата:

Hi,

 

I’m looking for some advice on how to determine the DB size on disk to trigger some cleanup tasks (deleting old data) if some threshold is reached.

 

Let’s say that for simplicity I don’t want to ask for the size on disk to the OS, but rather to PostgreSQL itself. And I only have a single database other than the defaults (‘template’, etc).

 

In that scenario is using pg_database_size() reasonable? Does that function return the actual size on disk or is it a calculation? Is there a better alternative?

 

Thanks,

 

Damian

Re: Database size on disk

От
dinesh kumar
Дата:
On Mon, Oct 5, 2015 at 12:47 PM, Quiroga, Damian <damian.quiroga@intel.com> wrote:

Hi,

 

I’m looking for some advice on how to determine the DB size on disk to trigger some cleanup tasks (deleting old data) if some threshold is reached.

 

Let’s say that for simplicity I don’t want to ask for the size on disk to the OS, but rather to PostgreSQL itself. And I only have a single database other than the defaults (‘template’, etc).

 

In that scenario is using pg_database_size() reasonable? Does that function return the actual size on disk or is it a calculation? Is there a better alternative?

 


Yes, pg_database_size() gives the size from disk level. IIRC, it do "du -h <DB oid folder>" kind of method.


 

Thanks,

 

Damian




--