Re: Calculation of db size

>>>>> "Horst" == Horst Düster <horst(dot)duester(at)sourcepole(dot)ch> 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)