Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glaGd-0002sm-FX for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 14:09:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glaGc-0006jL-4y for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 14:09:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glaGb-0006en-SF for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 14:09:33 +0000 Received: from brisi.sourcepole.ch ([5.9.57.43]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glaGV-0008SO-3H for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 14:09:33 +0000 Received: from [109.70.118.174] (helo=[192.168.178.90]) by vilan-mail with esmtpsa (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.84_2) (envelope-from ) id 1glaGT-0005E1-GJ for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 15:09:25 +0100 To: pgsql-admin@lists.postgresql.org From: =?UTF-8?Q?Horst_D=c3=bcster?= Subject: Calculation of db size Openpgp: preference=signencrypt Autocrypt: addr=horst.duester@sourcepole.ch; prefer-encrypt=mutual; keydata= mQINBFmISOwBEACvsD+EgIoexVLVpSU/yNK6kKOgbxsMMeIJ4V6JEFCNyWFLjiDGt4eAZmGz 2U414TO8K/s9n3ck4qL1GCP8eFw4MK0r8wGql1Jna8cumr8Zjzrt72crF92ZcbIlKV7H/I6n Iln6UK11bCjf9+4PEmFhesRpc+vnHFrH17nUdVxpT+bqODFY09XIV7GON38opqZxuc7Y9GMO T1Kn4ETXBTZBuGKORDHa7aC9xTHobibttAJJ/ZXS6hexgpqPuOu90vRMLZaE1NQRX06+Uicf yomlYS96RFK0zjrTgbUjuuQhUWo9i8oXj5BTxKMQKJftQttcVuSPt61AVKZkIs5J6qE7b1qq nJGkHWazki++s8cOUSZouXRJ0yxzQJTY6yblg0Ey4OHMBdSbD9EiEpCXrMfIg2b06UTODvWp X7dnLSM0AXzE2S86u4nOO2VS1QJqtK2xH75wL6YY+Ob59H79+AkzwVOgR+oXubSLN/tjSq83 o/vUB4gM0QPj3HMKTxEOdwDEgDerM7Tf2mGMayczpJBPqNvs3AOGGifCYfU+gp4jygskxYxm MOlDZ8fJVSPfC77XB0nQ70bdQaX6LT40r59L2LLcNdY24IghmNE3ETs5OQ/bpRDSazaC3TSv +mP6/c29/tHUNVaj0S7WqbRM+3tgq1YGel4MKF+Kc8DBBsYl4QARAQABtCtIb3JzdCBEw7xz dGVyIDxob3JzdC5kdWVzdGVyQHNvdXJjZXBvbGUuY2g+iQI9BBMBCAAnBQJZiEjsAhsjBQkJ ZgGABQsJCAcCBhUICQoLAgQWAgMBAh4BAheAAAoJEJ9JHuWr5F/cVzQQAIJIYQ03i6KWGlje yC97/LLtEf1f5q+snOzOPi12U1/VQ/X85yZHW5QjalppVGPha5oxvUTWDneQPl0zhzCOXNwJ h1prFElznAVhN8e9mGhdIs/9a8ph7lK3Uzln5xCfqHg0/DyRf1UAnhGWhLE6QAV596qvq807 CzwvZ1JF2LqLRkqI/2AnuDDZ4Zfr837B0Hvl6DbKOMQZqaM2+4mIBwgv7/K08q+WD+dohrzo QPzm/ogsZmeVpDtMxKQV8YKw1+pjZzbMcpebpD+5JdlqDcJBbm0y/BRB3t4vLfr9auFiD8kw H/KK8+TSNAzML9PPBtjgEMp4Z521Y21PgNEDn1WOqCr45MBMM38Pc33qbx0Coe3xTpZMTmHK xbjF1KnXcqDQp/5Mt3u1ewTx1/N67tmkd9ZqEY8hZmRuwunQPZtIzogK8oP4twvLYiVZUoPl j71sm7TUoyIqTFAdYjSX2oVO6Drc8q4Cla9lOL3nhgh1vvDnEW1E5ksti/1vXFzuYgJXeiag SijRb5fIiiGJOh34thQA/KjjNVKPn7qpn7sdHCbKH/4HASfv0RG/PBIqG6ovay1ULFWD8Vxj YwRLm8JWMasOwHFq03KC18oTQMaE6sNm+36b0vCoHZKsmo6hBu82CvrlHJmMPovxfkF0T0jU TZiUWe83qFKDBaUP6sKwuQINBFmISOwBEACqG1S1fjBr7oVaTJz+u/BHtoJd5KqloUwHS2Gh CQEM0m7NJjtiaxinirAZdGLEPfxdklAJpuypII8UXEfJr/uFz23zMaS7kFrxMDNb/ucNDa4m FqmHed2XzYHwm0cNaHnZVD5587uwaqMHv6Ujd68+N4BvTYZQsNjnag/2bVL/gnuNp3eDa7Nt xPBG/022tdeAdWxpbM+SWHZcvw2CPjLk0PrbMU46a8qG5KqetpsDF80+q7txK1PFtnTB7frd hTmMcrbktBgzH/eie1O8cN5x+uonDOPlTv/VLPuLqfKdDJMsX3GDhGJi+9BxcU3pG99kBmF1 8qLbR5PA0A6hfk53GuWn5UdSWgGAJyanp/k1g5tX571hReI3qdzFTROFTwCkCshLPb7ZzHtK oX/zJQpXf/VdvwBdoQlnkpiRbfGy/tviTkhspftWHy+nHgeg04lZzBRAbwrBPlEroS+LDv0x 0l93acauKIWoFaewtUiQ4fyLQT/x0Vi05LSUwvM62WR6W+oxjgC+0U4OpmQIGcz0Vx6mfRRp tVXf6r1Z74mcRhKuTW21pVb81BKfrxFNJTfek2pW36nCnHT8okL64qtIGte3hLv03zVBnUmr jv1KLl/wIUNEVcGv5WzoYpGcpcjp6o6jBv6tM5Gm9jg2lUT4ahzIDdD9u/nUtRyijmlj2wAR AQABiQIlBBgBCAAPBQJZiEjsAhsMBQkJZgGAAAoJEJ9JHuWr5F/c92kP/1LBp6TCGLESRm5g xW3owwjSJ99Z332vZ73bbtpNE9jb++Hh5ka63/M9+2lE7FPUIQ9wEzzZW4UD7f+kji3/wHwa Z4W4qhiSX+ZjGnynpLQws4jljL1oR9hIkPitGbE0dU1h2SaUFv9EirxtlXFF+szh3TLW1auz IbnykU8GGdKxtZ+74w31GEyLmWYoWZZrLcCHIZr0mF8Js68o6HxAo7GVBpAeoJrYqz8NctZb 2mCsrk5VEnaQ7QtL8pBCRYqBUPY+Aq54L5yGfAEC5pWErSpZHlrkgUWpWAsesoabCqLA2FQr TFTcKNViNev0/tkxwLyu3BuO8RR7YAuFqj8O2O9+ip6b/LQJsFzdNgYaTQ7cf1myIcJp4mga OkKmv4QS2MgTdFixCrrRU3ylLxFMM7zDJx0zHkGs6J1k9DkhMZ78p0AlCH5IRWkBWRsfNcvz 3uHugEom2+zel6F/NXjJi5br3/0R/0DACAVxEWWYGu0VZNcDhgwwthtrXN8Z3agsdGTH3b/U zwsWdZWy+pnL6Dnseq1vgd0KuIplj5Wh/hSwa26m7bsGrdsnD7Muyd5VWZpVrw6RujzMw3xb 6Ko3c05rteW636SUq2bPjWFeQmvBuVFhUGLpuTk2KnAacbIXqAjwSuDHFJqPP+C2y7lCf2K5 3DVCVbLgkZzMNRID/fFp Message-ID: <3d17ce68-70b6-677c-311e-b05b5195ba35@sourcepole.ch> Date: Mon, 21 Jan 2019 15:09:24 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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