Postgres Pro
Downloads
Home   >   mailing lists

Calculation of Database Size in postgres - Mailing list pgsql-admin

From pavan95
Subject Calculation of Database Size in postgres
Date
Msg-id 1518603470895-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Calculation of Database Size in postgres  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view 
Hi all,

In postgres for knowing the size of a database we generally use the system
administration function "pg_database_size('database_name')".

I am curious to know how does this calculate internally from the pages(free
pages/fragmented pages/full pages) stored in the disk?

Thanks in advance!

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Sathesh S
Date:
Subject: Re: Disable /Suppress hostname checks while secured LDAP
Next
From: Laurenz Albe
Date:
Subject: Re: Calculation of Database Size in postgres