Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ujytS-00EK6M-W1 for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Aug 2025 11:34:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ujytR-0041c1-Oi for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Aug 2025 11:34:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ujvM8-00355r-A5 for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 07:48:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ujvM4-001BN7-34 for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 07:48:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=cuzO0in3e7pksHEVGVCpWhPIHKJhM4ILySlNl/+s3bQ=; b=n43hmnUMzYu0Kl6DequX1I/0kR fSyqoVwRFyOrOmabC9qgoIxLBdVihHAZJLOp6lyfZ3nCeLTS5QjxqSZ4wov0UXVdG9D6ocxgXTv0m qMSxzAoq7aUgCJj+ay3GkkjwUtI0uwvrh0QrCa5dL1hRHMfqHv2fr057w2ndh9wPk9MiWbBrYqRdh yD0kroZnAqkXUuYqyfXG7NDWLrvjqbcK+It9v6TY+tlqaYCoRish4JYEqRlSzMZveQGFoGMj+ELCh LzqySrMbSap660zwmg5PaD9C9DchVSRNBDqhV9qjC2DujY5JirsKNjawq8wA+XZPIAyvMZTpFfvyF Tq3JZrxQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ujvM4-003CTz-BU for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 07:48:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ujvM2-00681L-2f for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 07:48:03 +0000 Content-Type: multipart/mixed; boundary="===============3059693450452116338==" MIME-Version: 1.0 Subject: BUG #19014: Automatic aggressive VACUUM on template0 and template1 pg_shdepend runs every minute To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 1986comatose@gmail.com Reply-To: 1986comatose@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 07 Aug 2025 07:47:58 +0000 Message-ID: <19014-3b29e6cbcb5f0b82@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3059693450452116338== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAxNApMb2dnZWQgYnk6ICAgICAgICAgIOyWkeyjvO2drApFbWFpbCBh ZGRyZXNzOiAgICAgIDE5ODZjb21hdG9zZUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ny40Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0LjIgTFRTIEphbW15CkRlc2NyaXB0 aW9uOiAgICAgICAgCgpXZSBvbmx5IGFjdGl2ZWx5IHVzZSB0aGUgZWNvdW50IGRhdGFiYXNlLCB5 ZXQgb3VyIGxvZ3Mgc2hvdyB0aGF0IGFuCmF1dG9tYXRpYyDigJxhZ2dyZXNzaXZl4oCdIFZBQ1VV TSBpcyByZXBlYXRlZGx5IHJ1bm5pbmcgb24KdGVtcGxhdGUwLnBnX2NhdGFsb2cucGdfc2hkZXBl bmQgYW5kIHRlbXBsYXRlMS5wZ19jYXRhbG9nLnBnX3NoZGVwZW5kIGF0CnJvdWdobHkgb25lLW1p bnV0ZSBpbnRlcnZhbHMuIFNpbmNlIHRoZSB0ZW1wbGF0ZSBkYXRhYmFzZXMgYXJlbuKAmXQgdXNl ZCBmb3IKbm9ybWFsIG9wZXJhdGlvbnMsIHRoZXNlIHZhY3V1bXMgc2VlbSB1bm5lY2Vzc2FyeSBh bmQgYXJlIGNvbnN1bWluZyBzeXN0ZW0KcmVzb3VyY2VzLiBXZSBiZWxpZXZlIHRoaXMgYmVoYXZp b3IgaXMgYSBidWcuCgpDdXJyZW50IEVudmlyb25tZW50OgoKClNFTEVDVCBkYXRuYW1lLCBteGlk X2FnZShkYXRtaW5teGlkKSwgYWdlKGRhdGZyb3plbnhpZCkKICBGUk9NIHBnX2NhdGFsb2cucGdf ZGF0YWJhc2U7CgoKCiBkYXRuYW1lICAgICAgICAgICB8IG1pbm14aWRfYWdlIHwgZnJvemVueGlk X2FnZQotLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tCiBl Y291bnQgICAgICAgICAgICB8ICAgICAgICAgICA4IHwgICAgIDEyOTg1MjMwOAogZWNvdW50X2Vj YmFjayAgICAgfCAgICAgICAgICAyNiB8ICAgICA0NjE3NTA0OTgKIHRlbXBsYXRlMCAgICAgICAg IHwgICAgICAgICAgIDggfCAgICAgMTU1NDU4NzczCiBwb3N0Z3JlcyAgICAgICAgICB8ICAgICAg ICAgIDI2IHwgICAgIDQ2MTc3NDgyNgogemFiYml4ICAgICAgICAgICAgfCAgICAgICAgICAyNiB8 ICAgICA0NjE3NjIzNjkKIHRlbXBsYXRlMSAgICAgICAgIHwgICAgICAgICAgIDggfCAgICAgMTU1 NDU1MjUxCgoKCk9ic2VydmVkIFZBQ1VVTSBMb2dzIChldmVyeSBcfjEgbWludXRlKToKCgoyMDI1 LTA4LTA3IDA5OjU2OjM0Ljc0NyBLU1QgWzQ0ODcwMl1bXVtdTE9HOiBhdXRvbWF0aWMgYWdncmVz c2l2ZSB2YWN1dW0gb2YKdGFibGUgInRlbXBsYXRlMS5wZ19jYXRhbG9nLnBnX3NoZGVwZW5kIjog aW5kZXggc2NhbnM6IDEKMjAyNS0wOC0wNyAxMDoxNDoxMi4zMjMgS1NUIFs2MTc4NTRdW11bXUxP RzogYXV0b21hdGljIGFnZ3Jlc3NpdmUgdmFjdXVtIG9mCnRhYmxlICJ0ZW1wbGF0ZTEucGdfY2F0 YWxvZy5wZ19zaGRlcGVuZCI6IGluZGV4IHNjYW5zOiAxCjIwMjUtMDgtMDcgMTA6MzI6NDMuMDQz IEtTVCBbNzk1NjUwXVtdW11MT0c6IGF1dG9tYXRpYyBhZ2dyZXNzaXZlIHZhY3V1bSBvZgp0YWJs ZSAidGVtcGxhdGUxLnBnX2NhdGFsb2cucGdfc2hkZXBlbmQiOiBpbmRleCBzY2FuczogMQoyMDI1 LTA4LTA3IDExOjAwOjIwLjI4OCBLU1QgWzEwNjEyMDhdW11bXUxPRzogYXV0b21hdGljIGFnZ3Jl c3NpdmUgdmFjdXVtIG9mCnRhYmxlICJ0ZW1wbGF0ZTAucGdfY2F0YWxvZy5wZ19zaGRlcGVuZCI6 IGluZGV4IHNjYW5zOiAxCjIwMjUtMDgtMDcgMTE6MTc6NDYuMDUzIEtTVCBbMTIyODI1MF1bXVtd TE9HOiBhdXRvbWF0aWMgYWdncmVzc2l2ZSB2YWN1dW0gb2YKdGFibGUgInRlbXBsYXRlMC5wZ19j YXRhbG9nLnBnX3NoZGVwZW5kIjogaW5kZXggc2NhbnM6IDEKMjAyNS0wOC0wNyAxMToyNzowMS44 ODAgS1NUIFsxMzE2NjU5XVtdW11MT0c6IGF1dG9tYXRpYyBhZ2dyZXNzaXZlIHZhY3V1bSBvZgp0 YWJsZSAidGVtcGxhdGUwLnBnX2NhdGFsb2cucGdfc2hkZXBlbmQiOiBpbmRleCBzY2FuczogMQoy MDI1LTA4LTA3IDEyOjAxOjI2LjA0NyBLU1QgWzE2NDgwNTddW11bXUxPRzogYXV0b21hdGljIGFn Z3Jlc3NpdmUgdmFjdXVtIG9mCnRhYmxlICJ0ZW1wbGF0ZTAucGdfY2F0YWxvZy5wZ19zaGRlcGVu ZCI6IGluZGV4IHNjYW5zOiAxCjIwMjUtMDgtMDcgMTI6MTk6MDIuMzM5IEtTVCBbMTgxNjk0NF1b XVtdTE9HOiBhdXRvbWF0aWMgYWdncmVzc2l2ZSB2YWN1dW0gb2YKdGFibGUgInRlbXBsYXRlMS5w Z19jYXRhbG9nLnBnX3NoZGVwZW5kIjogaW5kZXggc2NhbnM6IDEKMjAyNS0wOC0wNyAxMjoyODow Mi41NDMgS1NUIFsxOTAzMzk0XVtdW11MT0c6IGF1dG9tYXRpYyBhZ2dyZXNzaXZlIHZhY3V1bSBv Zgp0YWJsZSAidGVtcGxhdGUxLnBnX2NhdGFsb2cucGdfc2hkZXBlbmQiOiBpbmRleCBzY2Fuczog MQoyMDI1LTA4LTA3IDEzOjIzOjU5Ljc1MCBLU1QgWzI0NDIyMjddW11bXUxPRzogYXV0b21hdGlj IGFnZ3Jlc3NpdmUgdmFjdXVtIG9mCnRhYmxlICJ0ZW1wbGF0ZTEucGdfY2F0YWxvZy5wZ19zaGRl cGVuZCI6IGluZGV4IHNjYW5zOiAxCjIwMjUtMDgtMDcgMTM6MzM6MDAuNDQ4IEtTVCBbMjUyODg2 Ml1bXVtdTE9HOiBhdXRvbWF0aWMgYWdncmVzc2l2ZSB2YWN1dW0gb2YKdGFibGUgInRlbXBsYXRl MS5wZ19jYXRhbG9nLnBnX3NoZGVwZW5kIjogaW5kZXggc2NhbnM6IDEKMjAyNS0wOC0wNyAxMzo1 MTowNy4yNzkgS1NUIFsyNzAzMTY1XVtdW11MT0c6IGF1dG9tYXRpYyBhZ2dyZXNzaXZlIHZhY3V1 bSBvZgp0YWJsZSAidGVtcGxhdGUwLnBnX2NhdGFsb2cucGdfc2hkZXBlbmQiOiBpbmRleCBzY2Fu czogMQoyMDI1LTA4LTA3IDE0OjA4OjU2Ljc3MSBLU1QgWzI4NzU3NTldW11bXUxPRzogYXV0b21h dGljIGFnZ3Jlc3NpdmUgdmFjdXVtIG9mCnRhYmxlICJ0ZW1wbGF0ZTAucGdfY2F0YWxvZy5wZ19z aGRlcGVuZCI6IGluZGV4IHNjYW5zOiAxCjIwMjUtMDgtMDcgMTQ6MzY6MDMuNzMwIEtTVCBbMzEz NTczM11bXVtdTE9HOiBhdXRvbWF0aWMgYWdncmVzc2l2ZSB2YWN1dW0gb2YKdGFibGUgInRlbXBs YXRlMC5wZ19jYXRhbG9nLnBnX3NoZGVwZW5kIjogaW5kZXggc2NhbnM6IDEKMjAyNS0wOC0wNyAx NDo0NTowNC4zNjQgS1NUIFszMjIyMjI0XVtdW11MT0c6IGF1dG9tYXRpYyBhZ2dyZXNzaXZlIHZh Y3V1bSBvZgp0YWJsZSAidGVtcGxhdGUwLnBnX2NhdGFsb2cucGdfc2hkZXBlbmQiOiBpbmRleCBz Y2FuczogMQoKCkRldGFpbGVkIFZBQ1VVTSBPdXRwdXQgKGV4YW1wbGUgYXQgMTM6MjM6NTkpOgoK CjIwMjUtMDgtMDcgMTM6MjM6NTkuNzUwIEtTVCBbMjQ0MjIyN11bXVtdTE9HOiAgYXV0b21hdGlj IGFnZ3Jlc3NpdmUgdmFjdXVtCm9mIHRhYmxlICJ0ZW1wbGF0ZTEucGdfY2F0YWxvZy5wZ19zaGRl cGVuZCI6IGluZGV4IHNjYW5zOiAxCiAgICAgICAgcGFnZXM6IDAgcmVtb3ZlZCwgMTA4MTYgcmVt YWluLCA0MDcwIHNjYW5uZWQgKDM3LjYzJSBvZiB0b3RhbCkKICAgICAgICB0dXBsZXM6IDI0Mzc4 IHJlbW92ZWQsIDg5NDUxMSByZW1haW4sIDE1OSBhcmUgZGVhZCBidXQgbm90IHlldApyZW1vdmFi bGUKICAgICAgICByZW1vdmFibGUgY3V0b2ZmOiAxMTE0MzQzMTUxLCB3aGljaCB3YXMgMTAxMSBY SURzIG9sZCB3aGVuIG9wZXJhdGlvbgplbmRlZAogICAgICAgIG5ldyByZWxmcm96ZW54aWQ6IDEx MTQzNDMxNTEsIHdoaWNoIGlzIDU3ODMzNiBYSURzIGFoZWFkIG9mIHByZXZpb3VzCnZhbHVlCiAg ICAgICAgZnJvemVuOiAxMjYgcGFnZXMgZnJvbSB0YWJsZSAoMS4xNiUgb2YgdG90YWwpIGhhZCAx OTA1IHR1cGxlcyBmcm96ZW4KICAgICAgICBpbmRleCBzY2FuIG5lZWRlZDogMzkyNyBwYWdlcyBm cm9tIHRhYmxlICgzNi4zMSUgb2YgdG90YWwpIGhhZCAyOTk2NwpkZWFkIGl0ZW0gaWRlbnRpZmll cnMgcmVtb3ZlZAogICAgICAgIGluZGV4ICJwZ19zaGRlcGVuZF9kZXBlbmRlcl9pbmRleCI6IHBh Z2VzOiAyOTMzMSB0b3RhbCwgMTkyIG5ld2x5CmRlbGV0ZWQsIDMzMDcgY3VycmVudGx5IGRlbGV0 ZWQsIDMxMTUgcmV1c2FibGUKICAgICAgICBpbmRleCAicGdfc2hkZXBlbmRfcmVmZXJlbmNlX2lu ZGV4IjogcGFnZXM6IDIwNDAgdG90YWwsIDE1IG5ld2x5CmRlbGV0ZWQsIDEyMzQgY3VycmVudGx5 IGRlbGV0ZWQsIDEyMTkgcmV1c2FibGUKICAgICAgICBhdmcgcmVhZCByYXRlOiAzMS41MDAgTUIv cywgYXZnIHdyaXRlIHJhdGU6IDMuNTAzIE1CL3MKICAgICAgICBidWZmZXIgdXNhZ2U6IDM5NzA0 IGhpdHMsIDEyNzk2IG1pc3NlcywgMTQyMyBkaXJ0aWVkCiAgICAgICAgV0FMIHVzYWdlOiAxMjQ3 NCByZWNvcmRzLCAyNzgwIGZ1bGwgcGFnZSBpbWFnZXMsIDM2MDI1ODMgYnl0ZXMKICAgICAgICBz eXN0ZW0gdXNhZ2U6IENQVTogdXNlcjogMC4xNCBzLCBzeXN0ZW06IDAuMzIgcywgZWxhcHNlZDog My4xNyBzCgoKUmVsZXZhbnQgYXV0b3ZhY3V1bSBzZXR0aW5ncyAoZnJvbSBwb3N0Z3Jlc3FsLmNv bmYpOgoKCmF1dG92YWN1dW0gPSBvbgphdXRvdmFjdXVtX2FuYWx5emVfc2NhbGVfZmFjdG9yID0g MAphdXRvdmFjdXVtX2FuYWx5emVfdGhyZXNob2xkID0gMTAwMDAwMDAwCmF1dG92YWN1dW1fZnJl ZXplX21heF9hZ2UgPSA1MDAwMDAwMDAKYXV0b3ZhY3V1bV9tYXhfd29ya2VycyA9IDIKYXV0b3Zh Y3V1bV9tdWx0aXhhY3RfZnJlZXplX21heF9hZ2UgPSA0MDAwMDAwMDAKYXV0b3ZhY3V1bV9uYXB0 aW1lID0gNjAKYXV0b3ZhY3V1bV92YWN1dW1fY29zdF9kZWxheSA9IDUwCmF1dG92YWN1dW1fdmFj dXVtX2Nvc3RfbGltaXQgPSAtMQphdXRvdmFjdXVtX3ZhY3V1bV9pbnNlcnRfc2NhbGVfZmFjdG9y ID0gMAphdXRvdmFjdXVtX3ZhY3V1bV9pbnNlcnRfdGhyZXNob2xkID0gMzAwMDAKYXV0b3ZhY3V1 bV92YWN1dW1fc2NhbGVfZmFjdG9yID0gMC4xCmF1dG92YWN1dW1fdmFjdXVtX3RocmVzaG9sZCA9 IDUwCmF1dG92YWN1dW1fd29ya19tZW0gPSAtMQpsb2dfYXV0b3ZhY3V1bV9taW5fZHVyYXRpb24g PSAxMAp2YWN1dW1fYnVmZmVyX3VzYWdlX2xpbWl0ID0gMTAyNDAwCnZhY3V1bV9jb3N0X2RlbGF5 ID0gNTAKdmFjdXVtX2Nvc3RfbGltaXQgPSAyMDAwCnZhY3V1bV9jb3N0X3BhZ2VfZGlydHkgPSAy MAp2YWN1dW1fY29zdF9wYWdlX2hpdCA9IDEKdmFjdXVtX2Nvc3RfcGFnZV9taXNzID0gMgp2YWN1 dW1fZmFpbHNhZmVfYWdlID0gMTYwMDAwMDAwMAp2YWN1dW1fZnJlZXplX21pbl9hZ2UgPSA1MDAw MDAwMAp2YWN1dW1fZnJlZXplX3RhYmxlX2FnZSA9IDE1MDAwMDAwMAp2YWN1dW1fbXVsdGl4YWN0 X2ZhaWxzYWZlX2FnZSA9IDE2MDAwMDAwMDAKdmFjdXVtX211bHRpeGFjdF9mcmVlemVfbWluX2Fn ZSA9IDUwMDAwMDAKdmFjdXVtX211bHRpeGFjdF9mcmVlemVfdGFibGVfYWdlID0gMTUwMDAwMDAw CgoKUGxlYXNlIGxldCBtZSBrbm93IGlmIHlvdSBuZWVkIGFueSBmdXJ0aGVyIGluZm9ybWF0aW9u IG9yIHJlcHJvZHVjZXIgc3RlcHMuCgo= --===============3059693450452116338==--