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 1glWfK-0006Vz-2V for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 10:18:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glWfI-0000xU-8H for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 10:18:48 +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 1glWfH-0000xN-TZ for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 10:18:48 +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 1glWfD-00032R-RL for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 10:18:46 +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 1glWfB-0003kd-Cb for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 11:18:41 +0100 To: pgsql-admin@lists.postgresql.org From: =?UTF-8?Q?Horst_D=c3=bcster?= 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 Subject: Huge table pg_shdepend Message-ID: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch> Date: Mon, 21 Jan 2019 11:18:37 +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: quoted-printable Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi I'm struggling with a huge table pg_shdepend. My database has a size of 640MB exclude the size of the system tables. But the real size of the db is more than 2GB. The reason is a huge table pg_shdepend with more than 32000000 records.=C2=A0 PgAdmin3 shows a table size of 1885MB and an index size of 1690MB. This looks strange for me, because this size is a multiple amount of the db size itself. I believe, that there are a lot of rubbish in that table, but I'm not sure. I had run a vacuum full process, but this didn't help. Could anyone give me an advice how to clean the table pg_shdepend or reduce the table size?= Any hit would be appreciated. Regards Horst --=20 Dr. Horst D=C3=BCster Managing Director Sourcepole AG - Linux & Open Source Solutions=20 Weberstrasse 5, 8004 Z=C3=BCrich, 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