Postgres Pro
Downloads
Home   >   mailing lists

Re: Calculation of db size - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Calculation of db size
Date
Msg-id CAGDYbUMgT1PJ0dGsNGqvUnyhEgMH6itaTX6KGeepxoxwbcyOog@mail.gmail.com
Whole thread Raw
In response to Calculation of db size  (Horst Düster <horst.duester@sourcepole.ch>)
List pgsql-admin
Tree view
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 <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




pgsql-admin by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Calculation of db size
Next
From: Gary Stainburn
Date:
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8