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 1glY93-0002pR-Eo for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 11:53:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glY92-0001dR-5C for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 11:53:36 +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 1glY91-0001ad-Rq for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 11:53:35 +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 1glY8z-0005Hu-8L for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 11:53:35 +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 1glY8y-0004UW-4W; Mon, 21 Jan 2019 12:53:32 +0100 To: Zuhair Khayyat Cc: pgsql-admin@lists.postgresql.org References: <7ecdbaa3-07a6-1ec1-d991-06440c05b4cb@sourcepole.ch> 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: Re: Huge table pg_shdepend Message-ID: <6a9c1bdc-f88e-23ed-bd52-a1e7edac19bf@sourcepole.ch> Date: Mon, 21 Jan 2019 12:53:31 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------C5809EC0AFF5C81B8D2A86B4" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------C5809EC0AFF5C81B8D2A86B4 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi zuhair Thank's for your quick response. To use pg_repack it is not an option unfortunately, because it's not possible to install additional software at the db server. Are there other options to do with the postgresql onboard tools? Regards Horst Am 21.01.19 um 11:33 schrieb Zuhair Khayyat: > Hi Horst, > > Try pg_repack=C2=A0 > http://reorg.github.io/pg_repack/ > > On Mon, 21 Jan 2019 at 1:18 PM Horst D=C3=BCster > > wrot= e: > > 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, beca= use > this size is a multiple amount of the db size itself. I believe, th= at > 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 > 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 =C2= =A0 > http://www.sourcepole.ch > > qgiscloud.com - Karten einfach vom Desktop > ins Netz > > > > > > --=20 > =09 > Zuhair Khayyat Chief Technology Officer Lucidya > =C2=A0+966503418330 =C2=A0lucidya.com > > =C2=A0Please consider the environment before printing this email > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. This message contains confidential information and > is intended only for the individual named. If you are not the named > addressee you should not disseminate, distribute or copy this e-mail. > Please notify the sender immediately by e-mail if you have received > this e-mail by mistake and delete this e-mail from your system. If you > are not the intended recipient you are notified that disclosing, > copying, distributing or taking any action in reliance on the contents > of this information is strictly prohibited. > --=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 --------------C5809EC0AFF5C81B8D2A86B4 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+CiAgPGhlYWQ+CiAgICA8bWV0YSBodHRwLWVxdWl2PSJDb250ZW50LVR5cGUiIGNv bnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD1VVEYtOCI+CiAgPC9oZWFkPgogIDxib2R5IHRl eHQ9IiMwMDAwMDAiIGJnY29sb3I9IiNGRkZGRkYiPgogICAgSGkgenVoYWlyPGJyPgogICAg PGJyPgogICAgVGhhbmsncyBmb3IgeW91ciBxdWljayByZXNwb25zZS4gVG8gdXNlIHBnX3Jl cGFjayBpdCBpcyBub3QgYW4KICAgIG9wdGlvbiB1bmZvcnR1bmF0ZWx5LCBiZWNhdXNlIGl0 J3Mgbm90IHBvc3NpYmxlIHRvIGluc3RhbGwKICAgIGFkZGl0aW9uYWwgc29mdHdhcmUgYXQg dGhlIGRiIHNlcnZlci4gQXJlIHRoZXJlIG90aGVyIG9wdGlvbnMgdG8gZG8KICAgIHdpdGgg dGhlIHBvc3RncmVzcWwgb25ib2FyZCB0b29scz88YnI+CiAgICA8YnI+CiAgICBSZWdhcmRz PGJyPgogICAgSG9yc3Q8YnI+CiAgICA8YnI+CiAgICA8YnI+CiAgICA8YnI+CiAgICA8ZGl2 IGNsYXNzPSJtb3otY2l0ZS1wcmVmaXgiPkFtIDIxLjAxLjE5IHVtIDExOjMzIHNjaHJpZWIg WnVoYWlyCiAgICAgIEtoYXl5YXQ6PGJyPgogICAgPC9kaXY+CiAgICA8YmxvY2txdW90ZSB0 eXBlPSJjaXRlIgpjaXRlPSJtaWQ6Q0FEN2RpaW1xZlUxMj1vVVQwUHIxelphTmZETmhPNER6 Y3NoWTh4RkhvRDhYZHRyemN3QG1haWwuZ21haWwuY29tIj4KICAgICAgPG1ldGEgaHR0cC1l cXVpdj0iY29udGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9VVRGLTgi PgogICAgICA8ZGl2PgogICAgICAgIDxkaXYgZGlyPSJhdXRvIj5IaSBIb3JzdCw8L2Rpdj4K ICAgICAgPC9kaXY+CiAgICAgIDxkaXYgZGlyPSJhdXRvIj48YnI+CiAgICAgIDwvZGl2Pgog ICAgICA8ZGl2IGRpcj0iYXV0byI+VHJ5IHBnX3JlcGFja8KgCiAgICAgICAgPGRpdj48YSBo cmVmPSJodHRwOi8vcmVvcmcuZ2l0aHViLmlvL3BnX3JlcGFjay8iCiAgICAgICAgICAgIG1v ei1kby1ub3Qtc2VuZD0idHJ1ZSI+aHR0cDovL3Jlb3JnLmdpdGh1Yi5pby9wZ19yZXBhY2sv PC9hPjwvZGl2PgogICAgICA8L2Rpdj4KICAgICAgPGRpdj48YnI+CiAgICAgICAgPGRpdiBj bGFzcz0iZ21haWxfcXVvdGUiPgogICAgICAgICAgPGRpdiBkaXI9Imx0ciI+T24gTW9uLCAy MSBKYW4gMjAxOSBhdCAxOjE4IFBNIEhvcnN0IETDvHN0ZXIKICAgICAgICAgICAgJmx0Ozxh IGhyZWY9Im1haWx0bzpob3JzdC5kdWVzdGVyQHNvdXJjZXBvbGUuY2giCiAgICAgICAgICAg ICAgbW96LWRvLW5vdC1zZW5kPSJ0cnVlIj5ob3JzdC5kdWVzdGVyQHNvdXJjZXBvbGUuY2g8 L2E+Jmd0OwogICAgICAgICAgICB3cm90ZTo8YnI+CiAgICAgICAgICA8L2Rpdj4KICAgICAg ICAgIDxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAg MAogICAgICAgICAgICAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmct bGVmdDoxZXgiPkhpPGJyPgogICAgICAgICAgICA8YnI+CiAgICAgICAgICAgIEknbSBzdHJ1 Z2dsaW5nIHdpdGggYSBodWdlIHRhYmxlIHBnX3NoZGVwZW5kLiBNeSBkYXRhYmFzZQogICAg ICAgICAgICBoYXMgYSBzaXplIG9mPGJyPgogICAgICAgICAgICA2NDBNQiBleGNsdWRlIHRo ZSBzaXplIG9mIHRoZSBzeXN0ZW0gdGFibGVzLiBCdXQgdGhlIHJlYWwKICAgICAgICAgICAg c2l6ZSBvZiB0aGUgZGI8YnI+CiAgICAgICAgICAgIGlzIG1vcmUgdGhhbiAyR0IuIFRoZSBy ZWFzb24gaXMgYSBodWdlIHRhYmxlIHBnX3NoZGVwZW5kCiAgICAgICAgICAgIHdpdGggbW9y ZSB0aGFuPGJyPgogICAgICAgICAgICAzMjAwMDAwMCByZWNvcmRzLsKgIFBnQWRtaW4zIHNo b3dzIGEgdGFibGUgc2l6ZSBvZjxicj4KICAgICAgICAgICAgMTg4NU1CIGFuZCBhbiBpbmRl eCBzaXplIG9mIDE2OTBNQi4gVGhpcyBsb29rcyBzdHJhbmdlIGZvcgogICAgICAgICAgICBt ZSwgYmVjYXVzZTxicj4KICAgICAgICAgICAgdGhpcyBzaXplIGlzIGEgbXVsdGlwbGUgYW1v dW50IG9mIHRoZSBkYiBzaXplIGl0c2VsZi4gSQogICAgICAgICAgICBiZWxpZXZlLCB0aGF0 PGJyPgogICAgICAgICAgICB0aGVyZSBhcmUgYSBsb3Qgb2YgcnViYmlzaCBpbiB0aGF0IHRh YmxlLCBidXQgSSdtIG5vdCBzdXJlLjxicj4KICAgICAgICAgICAgPGJyPgogICAgICAgICAg ICBJIGhhZCBydW4gYSB2YWN1dW0gZnVsbCBwcm9jZXNzLCBidXQgdGhpcyBkaWRuJ3QgaGVs cC4gQ291bGQKICAgICAgICAgICAgYW55b25lIGdpdmU8YnI+CiAgICAgICAgICAgIG1lIGFu IGFkdmljZSBob3cgdG8gY2xlYW4gdGhlIHRhYmxlIHBnX3NoZGVwZW5kIG9yIHJlZHVjZQog ICAgICAgICAgICB0aGUgdGFibGUgc2l6ZT88YnI+CiAgICAgICAgICAgIDxicj4KICAgICAg ICAgICAgQW55IGhpdCB3b3VsZCBiZSBhcHByZWNpYXRlZC48YnI+CiAgICAgICAgICAgIDxi cj4KICAgICAgICAgICAgUmVnYXJkczxicj4KICAgICAgICAgICAgSG9yc3Q8YnI+CiAgICAg ICAgICAgIDxicj4KICAgICAgICAgICAgLS0gPGJyPgogICAgICAgICAgICBEci4gSG9yc3Qg RMO8c3Rlcjxicj4KICAgICAgICAgICAgTWFuYWdpbmcgRGlyZWN0b3I8YnI+CiAgICAgICAg ICAgIFNvdXJjZXBvbGUgQUcgLSBMaW51eCAmYW1wOyBPcGVuIFNvdXJjZSBTb2x1dGlvbnMg PGJyPgogICAgICAgICAgICA8YQpocmVmPSJodHRwczovL21hcHMuZ29vZ2xlLmNvbS8/cT1X ZWJlcnN0cmFzc2UrNSwrODAwNCtaJUMzJUJDcmljaCwrU3dpdHplcmxhbmQmYW1wO2VudHJ5 PWdtYWlsJmFtcDtzb3VyY2U9ZyIKICAgICAgICAgICAgICBtb3otZG8tbm90LXNlbmQ9InRy dWUiPldlYmVyc3RyYXNzZSA1LCA4MDA0IFrDvHJpY2gsCiAgICAgICAgICAgICAgU3dpdHpl cmxhbmQ8L2E+PGJyPgogICAgICAgICAgICBUZWw6ICs0MSAoMCk0NCA0NDAgNzcgMTE8YnI+ CiAgICAgICAgICAgIERpcmVrdDogKzQxICgwKTQ0IDUxNSA2NyA3MDxicj4KICAgICAgICAg ICAgPGEgaHJlZj0ibWFpbHRvOmhvcnN0LmR1ZXN0ZXJAc291cmNlcG9sZS5jaCIgdGFyZ2V0 PSJfYmxhbmsiCiAgICAgICAgICAgICAgbW96LWRvLW5vdC1zZW5kPSJ0cnVlIj5ob3JzdC5k dWVzdGVyQHNvdXJjZXBvbGUuY2g8L2E+wqAgPGEKICAgICAgICAgICAgICBocmVmPSJodHRw Oi8vd3d3LnNvdXJjZXBvbGUuY2giIHJlbD0ibm9yZWZlcnJlciIKICAgICAgICAgICAgICB0 YXJnZXQ9Il9ibGFuayIgbW96LWRvLW5vdC1zZW5kPSJ0cnVlIj5odHRwOi8vd3d3LnNvdXJj ZXBvbGUuY2g8L2E+PGJyPgogICAgICAgICAgICA8YnI+CiAgICAgICAgICAgIDxhIGhyZWY9 Imh0dHA6Ly9xZ2lzY2xvdWQuY29tIiByZWw9Im5vcmVmZXJyZXIiCiAgICAgICAgICAgICAg dGFyZ2V0PSJfYmxhbmsiIG1vei1kby1ub3Qtc2VuZD0idHJ1ZSI+cWdpc2Nsb3VkLmNvbTwv YT4gLQogICAgICAgICAgICBLYXJ0ZW4gZWluZmFjaCB2b20gRGVza3RvcCBpbnMgTmV0ejxi cj4KICAgICAgICAgICAgPGJyPgogICAgICAgICAgICA8YnI+CiAgICAgICAgICAgIDxicj4K ICAgICAgICAgICAgPGJyPgogICAgICAgICAgICA8YnI+CiAgICAgICAgICA8L2Jsb2NrcXVv dGU+CiAgICAgICAgPC9kaXY+CiAgICAgIDwvZGl2PgogICAgICAtLSA8YnI+CiAgICAgIDxk aXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9zaWduYXR1cmUiCiAgICAgICAgZGF0YS1zbWFy dG1haWw9ImdtYWlsX3NpZ25hdHVyZSI+CiAgICAgICAgPGRpdiBkaXI9Imx0ciI+CiAgICAg ICAgICA8cHJlIHN0eWxlPSJjb2xvcjpyZ2IoMCwwLDApO2ZvbnQtZmFtaWx5Ok1lbmxvO2Zv bnQtc2l6ZTo5cHQiPjx0YWJsZSBydWxlcz0ibm9uZSIgc3R5bGU9ImZvbnQtZmFtaWx5Oi13 ZWJraXQtc3RhbmRhcmQ7d2hpdGUtc3BhY2U6bm9ybWFsO2JvcmRlcjowcHgiIHdpZHRoPSIz MTMiIGNlbGxzcGFjaW5nPSIwIiBjZWxscGFkZGluZz0iMCIgYm9yZGVyPSIwIj48dGJvZHk+ PHRyPjx0ZD48dGFibGUgc3R5bGU9ImJvcmRlcjowcHgiIGNlbGxzcGFjaW5nPSIwIiBjZWxs cGFkZGluZz0iMCIgYm9yZGVyPSIwIj48dGJvZHk+PHRyPjx0ZCBzdHlsZT0iYm9yZGVyOjBw eDtwYWRkaW5nLXJpZ2h0OjNweCI+PGltZyBzcmM9Imh0dHA6Ly9sdWNpZHlhLmNvbS9zaWdu YXR1cmUvbG9nby5wbmciIG1vei1kby1ub3Qtc2VuZD0idHJ1ZSIgd2lkdGg9IjE1MiIgaGVp Z2h0PSI3NiIgYm9yZGVyPSJub25lIj48L3RkPjx0ZCBzdHlsZT0iYm9yZGVyOjBweDt3aWR0 aDoyMHB4O3BhZGRpbmc6NXB4O2xpbmUtaGVpZ2h0OjFweCI+PGEgaHJlZj0iaHR0cHM6Ly93 d3cudHdpdHRlci5jb20vbHVjaWR5YSIgc3R5bGU9ImxpbmUtaGVpZ2h0OjFweDt3aWR0aDoy MHB4O2hlaWdodDoyMHB4O2Rpc3BsYXk6aW5saW5lLWJsb2NrO3RleHQtYWxpZ246Y2VudGVy O3BhZGRpbmctdG9wOjBweDtwYWRkaW5nLWJvdHRvbTo0cHgiIHRhcmdldD0iX2JsYW5rIiBt b3otZG8tbm90LXNlbmQ9InRydWUiPjxpbWcgc3JjPSJodHRwOi8vbHVjaWR5YS5jb20vc2ln bmF0dXJlL3R3aXR0ZXIucG5nIiBtb3otZG8tbm90LXNlbmQ9InRydWUiIHdpZHRoPSIyMCIg aGVpZ2h0PSIyMCIgYm9yZGVyPSJub25lIj48L2E+PGEgaHJlZj0iaHR0cHM6Ly93d3cubGlu a2VkaW4uY29tL2NvbXBhbnkvbHVjaWR5YS8iIHN0eWxlPSJsaW5lLWhlaWdodDoxcHg7d2lk dGg6MjBweDtoZWlnaHQ6MjBweDtkaXNwbGF5OmlubGluZS1ibG9jazt0ZXh0LWFsaWduOmNl bnRlcjtwYWRkaW5nLXRvcDowcHg7cGFkZGluZy1ib3R0b206NHB4IiB0YXJnZXQ9Il9ibGFu ayIgbW96LWRvLW5vdC1zZW5kPSJ0cnVlIj48aW1nIHNyYz0iaHR0cDovL2x1Y2lkeWEuY29t L3NpZ25hdHVyZS9saW5rZWRpbi5wbmciIG1vei1kby1ub3Qtc2VuZD0idHJ1ZSIgd2lkdGg9 IjIwIiBoZWlnaHQ9IjIwIiBib3JkZXI9Im5vbmUiPjwvYT48YSBocmVmPSJodHRwczovL3d3 dy5mYWNlYm9vay5jb20vbHVjaWR5YSIgc3R5bGU9ImxpbmUtaGVpZ2h0OjFweDt3aWR0aDoy MHB4O2hlaWdodDoyMHB4O2Rpc3BsYXk6aW5saW5lLWJsb2NrO3RleHQtYWxpZ246Y2VudGVy O3BhZGRpbmctdG9wOjBweCIgdGFyZ2V0PSJfYmxhbmsiIG1vei1kby1ub3Qtc2VuZD0idHJ1 ZSI+PGltZyBzcmM9Imh0dHA6Ly9sdWNpZHlhLmNvbS9zaWduYXR1cmUvZmFjZWJvb2sucG5n IiBtb3otZG8tbm90LXNlbmQ9InRydWUiIHdpZHRoPSIyMCIgaGVpZ2h0PSIyMCIgYm9yZGVy PSJub25lIj48L2E+PC90ZD48dGQgc3R5bGU9ImJvcmRlci13aWR0aDowcHggMHB4IDBweCAx cHg7Ym9yZGVyLWxlZnQtc3R5bGU6ZGFzaGVkO2JvcmRlci1sZWZ0LWNvbG9yOnJnYigxMTYs MTIyLDEyNik7cGFkZGluZy1sZWZ0OjVweDtsaW5lLWhlaWdodDoxNXB4IiB2YWxpZ249InRv cCI+PHRhYmxlIGNlbGxzcGFjaW5nPSIwIiBjZWxscGFkZGluZz0iMCIgYm9yZGVyPSIwIj48 dGJvZHk+PHRyPjx0ZCBzdHlsZT0iYm9yZGVyOjBweDtwYWRkaW5nLWJvdHRvbToxMHB4O2xp bmUtaGVpZ2h0OjEycHgiIG5vd3JhcD0ibm93cmFwIj48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6SGVsdmV0aWNhLHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHg7Y29sb3I6cmdiKDU0LDE1 OCwyMDQpO2xpbmUtaGVpZ2h0OjEycHg7Zm9udC13ZWlnaHQ6Ym9sZCI+WnVoYWlyIEtoYXl5 YXQKPC9zcGFuPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTpIZWx2ZXRpY2Esc2Fucy1zZXJp Zjtmb250LXNpemU6MTBweDtsaW5lLWhlaWdodDoxMXB4O2NvbG9yOnJnYigzNSw0MCw0NSki PkNoaWVmIFRlY2hub2xvZ3kgT2ZmaWNlcgo8L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtZmFt aWx5OkhlbHZldGljYSxzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxMXB4O2NvbG9yOnJnYigxNCwy MCwyNCk7bGluZS1oZWlnaHQ6MTJweDtmb250LXdlaWdodDpib2xkIj5MdWNpZHlhPC9zcGFu PjwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPSJmb250LXNpemU6MTFweDtsaW5lLWhlaWdodDox N3B4Ij48c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6bm93cmFwO2ZvbnQtZmFtaWx5OkhlbHZl dGljYSxzYW5zLXNlcmlmO2Rpc3BsYXk6aW5saW5lLWJsb2NrO2xpbmUtaGVpZ2h0OjE3cHg7 Y29sb3I6cmdiKDM1LDQwLDQ1KSI+PGltZyB2YWxpZ249ImJvdHRvbSIgc3JjPSJodHRwOi8v bHVjaWR5YS5jb20vc2lnbmF0dXJlL3Bob25lLnBuZyIgbW96LWRvLW5vdC1zZW5kPSJ0cnVl IiB3aWR0aD0iMTUiIGhlaWdodD0iMTUiIGJvcmRlcj0ibm9uZSI+wqA8YSBocmVmPSJ0ZWw6 Kzk2NjUwMzQxODMzMCIgc3R5bGU9ImNvbG9yOnJnYigzNSw0MCw0NSkiIHRhcmdldD0iX2Js YW5rIiBtb3otZG8tbm90LXNlbmQ9InRydWUiPis5NjY1MDM0MTgzMzA8L2E+PC9zcGFuPgo8 c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6bm93cmFwO2ZvbnQtZmFtaWx5OkhlbHZldGljYSxz YW5zLXNlcmlmO2Rpc3BsYXk6aW5saW5lLWJsb2NrO2xpbmUtaGVpZ2h0OjE3cHg7Y29sb3I6 cmdiKDM1LDQwLDQ1KSI+PGltZyB2YWxpZ249ImJvdHRvbSIgc3JjPSJodHRwOi8vbHVjaWR5 YS5jb20vc2lnbmF0dXJlL3dlYnNpdGUucG5nIiBtb3otZG8tbm90LXNlbmQ9InRydWUiIHdp ZHRoPSIxNSIgaGVpZ2h0PSIxNSIgYm9yZGVyPSJub25lIj7CoDxhIGhyZWY9Imh0dHA6Ly9s dWNpZHlhLmNvbSIgc3R5bGU9ImNvbG9yOnJnYigzNSw0MCw0NSkiIHRhcmdldD0iX2JsYW5r IiBtb3otZG8tbm90LXNlbmQ9InRydWUiPmx1Y2lkeWEuY29tPC9hPjwvc3Bhbj4KPC90ZD48 L3RyPjwvdGJvZHk+PC90YWJsZT48L3RkPjwvdHI+PC90Ym9keT48L3RhYmxlPjwvdGQ+PC90 cj48dHI+PHRkIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHg7Ym9yZGVyOjBweCI+CjwvdGQ+PC90 cj48dHI+PHRkIHN0eWxlPSJwYWRkaW5nLXRvcDoxMHB4O2JvcmRlcjowcHg7Zm9udC1zaXpl OjExcHgiIHZhbGlnbj0iYm90dG9tIj48c3BhbiBzdHlsZT0iZGlzcGxheTp0YWJsZS1jZWxs O3ZlcnRpY2FsLWFsaWduOmJvdHRvbTtmb250LWZhbWlseTpIZWx2ZXRpY2Esc2Fucy1zZXJp ZjtsaW5lLWhlaWdodDoxN3B4Ij48aW1nIHZhbGlnbj0iYm90dG9tIiBzcmM9Imh0dHA6Ly9s dWNpZHlhLmNvbS9zaWduYXR1cmUvbGVhZjIucG5nIiBtb3otZG8tbm90LXNlbmQ9InRydWUi IHdpZHRoPSIxNyIgaGVpZ2h0PSIxNyIgYm9yZGVyPSJub25lIj7CoDxzcGFuIHN0eWxlPSJj b2xvcjpyZ2IoNzYsODEsODYpIj5QbGVhc2UgY29uc2lkZXIgdGhlIGVudmlyb25tZW50IGJl Zm9yZSBwcmludGluZyB0aGlzIGVtYWlsPC9zcGFuPjwvc3Bhbj48L3RkPjwvdHI+PHRyPjx0 ZCBzdHlsZT0icGFkZGluZzoxMHB4IDBweCAwcHg7Ym9yZGVyOjBweDtsaW5lLWhlaWdodDox MXB4O21heC13aWR0aDowcHg7d29yZC1icmVhazpicmVhay13b3JkIiBhbGlnbj0ibGVmdCI+ PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OkhlbHZldGljYSxzYW5zLXNlcmlmO2NvbG9yOnJn YigzNSw0MCw0NSk7bGluZS1oZWlnaHQ6MTFweDtmb250LXNpemU6OXB4Ij5UaGlzIGVtYWls IGFuZCBhbnkgZmlsZXMgdHJhbnNtaXR0ZWQgd2l0aCBpdCBhcmUgY29uZmlkZW50aWFsIGFu ZCBpbnRlbmRlZCBzb2xlbHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwgb3IgZW50 aXR5IHRvIHdob20gdGhleSBhcmUgYWRkcmVzc2VkLiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0 aGlzIGVtYWlsIGluIGVycm9yIHBsZWFzZSBub3RpZnkgdGhlIHN5c3RlbSBtYW5hZ2VyLiBU aGlzIG1lc3NhZ2UgY29udGFpbnMgY29uZmlkZW50aWFsIGluZm9ybWF0aW9uIGFuZCBpcyBp bnRlbmRlZCBvbmx5IGZvciB0aGUgaW5kaXZpZHVhbCBuYW1lZC4gSWYgeW91IGFyZSBub3Qg dGhlIG5hbWVkIGFkZHJlc3NlZSB5b3Ugc2hvdWxkIG5vdCBkaXNzZW1pbmF0ZSwgZGlzdHJp YnV0ZSBvciBjb3B5IHRoaXMgZS1tYWlsLiBQbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgaW1t ZWRpYXRlbHkgYnkgZS1tYWlsIGlmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgZS1tYWlsIGJ5 IG1pc3Rha2UgYW5kIGRlbGV0ZSB0aGlzIGUtbWFpbCBmcm9tIHlvdXIgc3lzdGVtLiBJZiB5 b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IHlvdSBhcmUgbm90aWZpZWQgdGhh dCBkaXNjbG9zaW5nLCBjb3B5aW5nLCBkaXN0cmlidXRpbmcgb3IgdGFraW5nIGFueSBhY3Rp b24gaW4gcmVsaWFuY2Ugb24gdGhlIGNvbnRlbnRzIG9mIHRoaXMgaW5mb3JtYXRpb24gaXMg c3RyaWN0bHkgcHJvaGliaXRlZC48L3NwYW4+PC90ZD48L3RyPjwvdGJvZHk+PC90YWJsZT48 L3ByZT4KICAgICAgICA8L2Rpdj4KICAgICAgPC9kaXY+CiAgICA8L2Jsb2NrcXVvdGU+CiAg ICA8YnI+CiAgICA8cHJlIGNsYXNzPSJtb3otc2lnbmF0dXJlIiBjb2xzPSI3MiI+LS0gCkRy LiBIb3JzdCBEw7xzdGVyCk1hbmFnaW5nIERpcmVjdG9yClNvdXJjZXBvbGUgQUcgLSBMaW51 eCAmYW1wOyBPcGVuIFNvdXJjZSBTb2x1dGlvbnMgCldlYmVyc3RyYXNzZSA1LCA4MDA0IFrD vHJpY2gsIFN3aXR6ZXJsYW5kClRlbDogKzQxICgwKTQ0IDQ0MCA3NyAxMQpEaXJla3Q6ICs0 MSAoMCk0NCA1MTUgNjcgNzAKPGEgY2xhc3M9Im1vei10eHQtbGluay1hYmJyZXZpYXRlZCIg aHJlZj0ibWFpbHRvOmhvcnN0LmR1ZXN0ZXJAc291cmNlcG9sZS5jaCI+aG9yc3QuZHVlc3Rl ckBzb3VyY2Vwb2xlLmNoPC9hPiAgPGEgY2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4dCIg aHJlZj0iaHR0cDovL3d3dy5zb3VyY2Vwb2xlLmNoIj5odHRwOi8vd3d3LnNvdXJjZXBvbGUu Y2g8L2E+CgpxZ2lzY2xvdWQuY29tIC0gS2FydGVuIGVpbmZhY2ggdm9tIERlc2t0b3AgaW5z IE5ldHoKCgoKPC9wcmU+CiAgPC9ib2R5Pgo8L2h0bWw+Cg== --------------C5809EC0AFF5C81B8D2A86B4--