Calculation of db size

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Calculation of db size

Horst Düster
Then I have a subsequent question.

Does the query

SELECT g_database_size('dbname');

take into account the storage space of the table pg_shdepend or not?

Regards
Horst

--
Dr. Horst Düster
Managing Director
Sourcepole AG - Linux & Open Source Solutions
Weberstrasse 5, 8004 Zürich, Switzerland
Tel: +41 (0)44 440 77 11
Direkt: +41 (0)44 515 67 70
[hidden email]  http://www.sourcepole.ch

qgiscloud.com - Karten einfach vom Desktop ins Netz




Reply | Threaded
Open this post in threaded view
|

Re: Calculation of db size

Andrew Gierth
>>>>> "Horst" == Horst Düster <[hidden email]> writes:

 Horst> Then I have a subsequent question.

 Horst> Does the query

 Horst> SELECT g_database_size('dbname');

 Horst> take into account the storage space of the table pg_shdepend or
 Horst> not?

It does not. Nor does it include the other global tables, such as
pg_database, pg_authid, etc. To get the list of global tables and their
indexes, use:

select relname from pg_class where relisshared;  

The size of the global tables and indexes, which don't count towards the
size of any individual database, can be obtained with
pg_tablespace_size('pg_global'). (All global tables must be in the
pg_global tablespace, and no other tables are allowed there.)

--
Andrew (irc:RhodiumToad)

Reply | Threaded
Open this post in threaded view
|

Re: Calculation of db size

Shreeyansh dba
In reply to this post by Horst Düster
Yes, pg_database_size() includes all disk space used by the database i.e. catalog tables or user data.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Mon, Jan 21, 2019 at 7:39 PM Horst Düster <[hidden email]> wrote:
Then I have a subsequent question.

Does the query

SELECT g_database_size('dbname');

take into account the storage space of the table pg_shdepend or not?

Regards
Horst

--
Dr. Horst Düster
Managing Director
Sourcepole AG - Linux & Open Source Solutions
Weberstrasse 5, 8004 Zürich, Switzerland
Tel: +41 (0)44 440 77 11
Direkt: +41 (0)44 515 67 70
[hidden email]  http://www.sourcepole.ch

qgiscloud.com - Karten einfach vom Desktop ins Netz