Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Calculation of Database Size in postgres
Date
Msg-id 1518603681.2402.0.camel@cybertec.at
Whole thread Raw
In response to Calculation of Database Size in postgres  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Calculation of Database Size in postgres  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view 
pavan95 wrote:
> 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?

It just adds up the sizes of the files that make up the database.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Calculation of Database Size in postgres
Next
From: pavan95
Date:
Subject: Re: Calculation of Database Size in postgres