Re: [GENERAL] Database size on disk

[dinesh kumar]

On Mon, Oct 5, 2015 at 12:47 PM, Quiroga, Damian 
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
" kind of method.




> Thanks,
>
>
>
> Damian
>



-- 

Regards,
Dinesh
manojadinesh.blogspot.com

[GENERAL] 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