Обсуждение: Calculation of db size
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 horst.duester@sourcepole.ch http://www.sourcepole.ch qgiscloud.com - Karten einfach vom Desktop ins Netz
>>>>> "Horst" == Horst Düster <horst.duester@sourcepole.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)
Yes, pg_database_size() includes all disk space used by the database i.e. catalog tables or user data.
On Mon, Jan 21, 2019 at 7:39 PM Horst Düster <horst.duester@sourcepole.ch> 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
horst.duester@sourcepole.ch http://www.sourcepole.ch
qgiscloud.com - Karten einfach vom Desktop ins Netz