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 1glZyn-0001T6-IM for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 13:51:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glZyk-0001AK-K7 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 13:51:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glZyk-0001AD-9C for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 13:51:06 +0000 Received: from brisi.sourcepole.ch ([5.9.57.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glZyg-0007mi-Ut for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 13:51:05 +0000 Received: from [193.192.231.218] (helo=linux.fritz.box) by vilan-mail with esmtpsa (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.84_2) (envelope-from ) id 1glZye-00057C-CW for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 14:51:00 +0100 Subject: Re: Huge table pg_shdepend To: pgsql-admin@lists.postgresql.org References: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch> <87o98a468n.fsf@news-spur.riddles.org.uk> From: =?UTF-8?Q?Horst_D=c3=bcster?= Openpgp: preference=signencrypt Autocrypt: addr=horst.duester@sourcepole.ch; prefer-encrypt=mutual; keydata= mQINBFsWLaoBEADBcT2RYsPuNuiyjNhLRVLPqUyPE0fLkHVthRctUlilYtSZhYjx/6KSFSXk ai1GuTQFtP022SJel9PEig9cRGfBc0q/Pc9BKqnq8VZhMGKSzcXJHTM85duLakdBIWY/7lap wlVmjTtzemsY+RayZXt5tD8uPKKa4Dk8LJoouxN91j6+Y4OXNexXXRUF+2BMEDo+NFMtTh/r eygOzzdeVKYP+j48ETvzLmRf45UHGMha3pEaHIshZNOhuvbNilP+Ehs44pKVZ7xmHRbrvbIp u2PCBD6/nIAtKqjsuIkwVo50WLiIxMzkCEvnaI2DlZ/uU1SCzeHnmJOi/u+IdPLyNHUfw2Uv vKWxZZV9YKsEiKYniFCvJdAbST75AT28nY/qxocx2EZv0sAaXRD/xovgdzahFilRiB+Ymcmf CYq3/kLKsgCX7jreqzYHW1vCHY7sdhcPzRGefWrA6RNa8h70+yuoAwS5raHQpPsxqpyOBeZp IipWYw8+n85QoOnA/eiN/2RNQ4zelWM5AnTtsqMCz5Pqg9nV0GEzFpATD4Y+WfjMOQFxHVSC C1lJEwFneCy0kSZw2QiuRT2x2G3SdVa6nx7LQ5YMe1DU45P6EXWgZJ+XsfQHtODggUQ8fnMP 2qGE8IjbfqN0z24E+ICaveWUa7WIhAiqP2rg1LbgJ2OkhRytDwARAQABtCtIb3JzdCBEw7xz dGVyIDxob3JzdC5kdWVzdGVyQHNvdXJjZXBvbGUuY2g+iQJOBBMBCgA4FiEEjyhxBt/l+OIa UmQDMfqNiZRDQtQFAlsWLaoCGyMFCwkIBwIGFQoJCAsCBBYCAwECHgECF4AACgkQMfqNiZRD QtTMmBAAmLZmrEMDeFBD2jOj8TNTgBayjwx+/dMqOcjVSy0cl7oQ9nmf/eorepKHQd5pRvx0 6q0YSpaGqYROPyC2+72K5tNsGmH73qnh0COiha2pdpGkwZZXfVBpd8K0LgGT9FIuJRCS0L00 7Ch5pRG1AbAmeAx12CCaybS2dAkZ1t/bJtb3zud3zY2b/cKJsbYpiyoZUHI8d/utAT+o9YJV /khlEKe+OFq0b0ps2Cm/1SPn9/JUkZj8K00O+sFh08jnmLGn1loHjQU55vkgb/WuikxlALXk aju6PtZ8DNd/VQsmygdWkMYK6BQqq5ejjKClPoN1Sb3ru/JHC5HMN4U0YqUcViWrmae64wFc 492Inpz16ShA/Wu4Oj5HwnBehBq0aYMLW7ojy6llPn56zGQsMRYVIrWkX6RExYNw+llZITfD Bcb++kAGZcO0Gz7c2ogJi7nH7p2UcsVhTJebLEVaCt3T1dnHH7GxhcVEdwSJrBL3QxUPG3Zh BNZaw6xoGUb7A48sHWK06noNynKm6tkzS4QfwIgZEgo39Sm4X8IMU+qEX+nOroCsxxCQlB14 QYT53Mv9yeeGPiZOoQxQq52nXi+TVYORQHfVoTokV7g7894H4x/RxKH5QlZRiCVYzR5o8tqe LJ6VxBVpUGJUIc98ZEAUEKpjQzl3l/LdTNqDEWqEE8m5Ag0EWxYtqgEQAMgtA5b3HY2tNKJG HhZaZq3gwJ6gV9/lwi4sJQDiTWInkWpsz0MCuvN3ONqTdGYFI/zVfQzVnxK58Ss8vw3EJkK4 HZRA4b+r5XWuWRbohVk3P4E2tO/XJdIRDyyOvj2PO7jATyT2JTamsG3OCD4OVMODV1YzO47B xdYjMqCYcemDJGZlvMee0feKX+SXOwg5Cla8l1RtcDDD6g1n9XQ6WyYJMdRDJPS0j9r41b8U uNjPDAUVCVI7ZKK9+3t3fMMB+7OL6VHkctShxMkR/KjTmzEGBycWBYjE3qzgyRFrMYcqWdaN wRZEb+Res1jQ/GWxaQZHair+tFKUbkFYfETvWhsT2z13t5LRMyitWl73s1qJQH6IEmDoN2ja D5eqgsDRn5j0ZZip2gjRH7r1+2mWkh0MNyJt/0paqE+ihjlWeNjZQFr5pxu3quSl1v8O8YdM EJWltOaz9W7KOq/p1dpJvDOhSjiFtXDSjXpO8ck+cp9TeOJfR5VhFcDwSVrIb8su+kbdT/ar y15+ZlcnaNCxdKV3mZM9tX+xeO2WQ65KIHbfpJvJZ1UL8SKfNRGNH+yqOTbP7zDCjfSJibPo ThK9k19zB2ERsRlqN8AAz39kARTngDhqVgo1QUvcpeKgL49yQhsf0I/MWZIOUBkcfTW4khen iLUpbLguZ0wSVlGr9dofABEBAAGJAjYEGAEKACAWIQSPKHEG3+X44hpSZAMx+o2JlENC1AUC WxYtqgIbDAAKCRAx+o2JlENC1MfwD/970i6pChnfwPlCEbmCcm06lWGXyQyahcRIEpnP3PA7 VN7+7u/bvr2xD0IrwKKhrsb2Oykt3OIi9W8jmZu7/smpc0ipfdxWr/4Xjp3fxB8tDg6yAQl1 9cq0FKZB3ZXol2psJzRDJ50n8j+0CK3CtcpaV8K6TDp0KcRYcNCXHZwmsaX62wLh+QIUdg7X T0nfswipuejol/BcdLzbNULe6ztF69+0x7TmRlWP42bbq6zEKK3WFfBlSNt4rz3vI1np9fLi tFIdyra7++5HzMZ4wJm0fokJ7+a/qrDBqKfddOibemU1nWBq3C2HrYFdEAFH0wXxf/hiXkTU ZBU2OukxyN2AwdgOmlvkbKqa+43DkwGtNPxTQOVkSE+DoXkyz/cyQG++cFduIbZmbMaMULpd J7oIsTeoBgmaxCqhYsmQ1WBxf1cC7pgLhHZiFrR9g5dzpw1wZDd7iQ7gZwSVG6Utg7EZ/ztJ tnEI+Rv9Em/W+/ZTQczUR9BMeixDwYeCyMGXTGhdAxdYaUVKM5p693RpR4sd5WxAe0+6gIEH RZO4oMjtXqlsj8ZrFI81rSJsTTP6L50hZ8OhGS+E7Yk7U/juViuuxgk5n1HeSx2G1zb85FZ9 XFRpBbKEfdcR0DdO1Yb9J5ecKaxm/wK9LCu7Q959yiPc4JQoZ20Cfqx5FLCgL/zhXg== Message-ID: Date: Mon, 21 Jan 2019 14:50:59 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <87o98a468n.fsf@news-spur.riddles.org.uk> 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 Am 21.01.19 um 12:19 schrieb Andrew Gierth: > Note that there's a single pg_shdepend table shared between all > databases in the cluster; it's not part of any single database but > rather is a "global" table. So what matters is the total number of > objects over all databases, not the size of any single db. OK that declares the size of the table. We have more than 50'000 databases in one cluster. 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