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 1rjfJF-0072ee-CC for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Mar 2024 13:03:18 +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 1rjfJC-00Dlnm-Sb for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Mar 2024 13:03:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjf5a-00DgZy-J4 for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 12:49:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjf5W-003vqS-S8 for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 12:49:10 +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=MoxMtFI5rmaz/C4wHRH0mGg5UppDY1u0WWi+EJVavok=; b=Z8THvsFf/5Wv4pgNGuR3JcA0hW sGa2ITAPQtivQLs3G07JCBDqheLpYAXkCNPBXglYJd+l/SKL8OOl4c/JGBCe/hBPctQUYUKLY9Ddf p+dY9V4yfu/Pl9rFgP5I+Q1iYvimj+ds2d5fG9N7u7luHntR52y+DtE9V2nFwSydO8u+OORAa9tfA YqinM4f+46ICt9Sc66g74HWvNGXd6pg45BP+mYeSxUg93X6bYXRjPKQvDz4YJun5n3/6dFkWR+Aya SA/SJ82uU0OH93prZyR6y9kc56Ned+xOa/UeK7ruieK67LIHpUU2OlN4ewmlreUmvtleh9AAfoSCj hSDZuIYg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjf5T-00A8Fk-Hs for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 12:49:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rjf5R-00Dxwl-TX for pgsql-bugs@lists.postgresql.org; Mon, 11 Mar 2024 12:49:02 +0000 Content-Type: multipart/mixed; boundary="===============7284593249100933101==" MIME-Version: 1.0 Subject: BUG #18386: Slow connection access after 'vacuum full pg_attribute' To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 1165125080@qq.com Reply-To: 1165125080@qq.com, pgsql-bugs@lists.postgresql.org Date: Mon, 11 Mar 2024 12:48:39 +0000 Message-ID: <18386-59bf41fb0332a05d@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 --===============7284593249100933101== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM4NgpMb2dnZWQgYnk6ICAgICAgICAgIGppIHhpYW9oYW5nCkVtYWls IGFkZHJlc3M6ICAgICAgMTE2NTEyNTA4MEBxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC44 Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zIDcKRGVzY3JpcHRpb246ICAgICAgICAKCkluIG15 IGRhdGFiYXNlLCB0aGVyZSBhcmUgYSBsb3Qgb2YgdGFibGVzIGFuZCB2aWV3cywgcmVzdWx0aW5n IGluIGEgbGFyZ2UKcGdfYXR0cmlidXRlIHRhYmxlLg0KSSB0aGVuIGRpZCBhIHZhY3V1bSBmdWxs IHBnX2F0dHJpYnV0ZSBhbmQgcmVzdGFydGVkIHRoZSBkYXRhYmFzZS4NCkxhdGVyLCBpdCB3YXMg Zm91bmQgdGhhdCB0aGUgZmlyc3QgbmV3IGNvbm5lY3Rpb24gdG9vayBzZXZlcmFsIG1pbnV0ZXMg dG8KY29ubmVjdCB0byB0aGUgZGF0YWJhc2UuDQpUaGUgc3RhY2sgZHVyaW5nIGNvbm5lY3Rpb24g YWNjZXNzIGlzIGFzIGZvbGxvd3M6DQoNCiMwICAweDAwMDA3ZmFlY2UxNDljNjQgaW4gcHJlYWQ2 NCAoKSBmcm9tIC91c3IvbGliNjQvbGlicHRocmVhZC5zby4wDQojMSAgMHgwMDAwNTViOTE5Yjhi YzBjIGluIEZpbGVSZWFkIChmaWxlPTExLCBidWZmZXI9MHg3ZmFlMzc5MDk1ODAKIlwwMzVcMDAy IiwgYW1vdW50PTgxOTIsIG9mZnNldD0xMDE5OTg1OTIwLCB3YWl0X2V2ZW50X2luZm89MTY3Nzcy MTczKSBhdApmZC5jOjE4ODkNCiMyICAweDAwMDA1NWI5MTliYmRmMzkgaW4gbWRyZWFkIChyZWxu PTB4NTViOTFiNmE5MTIwLCBmb3JrbnVtPU1BSU5fRk9SS05VTSwKYmxvY2tudW09Nzc5ODcwLCBi dWZmZXI9MHg3ZmFlMzc5MDk1ODAgIlwwMzVcMDAyIikgYXQgbWQuYzo2MzgNCiMzICAweDAwMDA1 NWI5MTliYmZlZmUgaW4gc21ncnJlYWQgKHJlbG49MHg1NWI5MWI2YTkxMjAsCmZvcmtudW09TUFJ Tl9GT1JLTlVNLCBibG9ja251bT03Nzk4NzAsIGJ1ZmZlcj0weDdmYWUzNzkwOTU4MCAiXDAzNVww MDIiKSBhdApzbWdyLmM6NTkwDQojNCAgMHgwMDAwNTViOTE5YjgzNzk3IGluIFJlYWRCdWZmZXJf Y29tbW9uIChzbWdyPTB4NTViOTFiNmE5MTIwLApyZWxwZXJzaXN0ZW5jZT0xMTIgJ3AnLCBmb3Jr TnVtPU1BSU5fRk9SS05VTSwgYmxvY2tOdW09Nzc5ODcwLAptb2RlPVJCTV9OT1JNQUwsIHN0cmF0 ZWd5PTB4NTViOTFiNjliNDkwLCBoaXQ9MHg3ZmZkYTUxZDllNDMpIGF0CmJ1Zm1nci5jOjkwMQ0K IzUgIDB4MDAwMDU1YjkxOWI4MmY4YyBpbiBSZWFkQnVmZmVyRXh0ZW5kZWQgKHJlbG49MHg3ZmFl MzU0OTU3NTgsCmZvcmtOdW09TUFJTl9GT1JLTlVNLCBibG9ja051bT03Nzk4NzAsIG1vZGU9UkJN X05PUk1BTCwKc3RyYXRlZ3k9MHg1NWI5MWI2OWI0OTApIGF0IGJ1Zm1nci5jOjY2MA0KIzYgIDB4 MDAwMDU1YjkxOTdiZDE4ZSBpbiBoZWFwZ2V0cGFnZSAoc3NjYW49MHg1NWI5MWI2OWE4ZDAsIHBh Z2U9Nzc5ODcwKSBhdApoZWFwYW0uYzozODMNCiM3ICAweDAwMDA1NWI5MTk3YmVjOGIgaW4gaGVh cGdldHR1cF9wYWdlbW9kZSAoc2Nhbj0weDU1YjkxYjY5YThkMCwKZGlyPUZvcndhcmRTY2FuRGly ZWN0aW9uLCBua2V5cz0yLCBrZXk9MHg1NWI5MWI2OWE0NTApIGF0IGhlYXBhbS5jOjEwNzkNCiM4 ICAweDAwMDA1NWI5MTk3YmYxYTEgaW4gaGVhcF9nZXRuZXh0c2xvdCAoc3NjYW49MHg1NWI5MWI2 OWE4ZDAsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgc2xvdD0weDU1YjkxYjY5YjFm MCkgYXQgaGVhcGFtLmM6MTM3Mg0KIzkgIDB4MDAwMDU1YjkxOTdlMmJmYSBpbiB0YWJsZV9zY2Fu X2dldG5leHRzbG90IChzc2Nhbj0weDU1YjkxYjY5YThkMCwKZGlyZWN0aW9uPUZvcndhcmRTY2Fu RGlyZWN0aW9uLCBzbG90PTB4NTViOTFiNjliMWYwKSBhdAouLi8uLi8uLi8uLi9zcmMvaW5jbHVk ZS9hY2Nlc3MvdGFibGVhbS5oOjg4OQ0KIzEwIDB4MDAwMDU1YjkxOTdlMzRiOCBpbiBzeXN0YWJs ZV9nZXRuZXh0IChzeXNzY2FuPTB4NTViOTFiNjlhNDAwKSBhdApnZW5hbS5jOjQ3MQ0KIzExIDB4 MDAwMDU1YjkxOWQzY2I0NCBpbiBSZWxhdGlvbkJ1aWxkVHVwbGVEZXNjIChyZWxhdGlvbj0weDdm YWUzNTQ5OTE3OCkKYXQgcmVsY2FjaGUuYzo1ODANCiMxMiAweDAwMDA1NWI5MTlkM2RkMDkgaW4g UmVsYXRpb25CdWlsZERlc2MgKHRhcmdldFJlbElkPTI2NjIsCmluc2VydEl0PXRydWUpIGF0IHJl bGNhY2hlLmM6MTIwNw0KIzEzIDB4MDAwMDU1YjkxOWQ0Mjg2NyBpbiBsb2FkX2NyaXRpY2FsX2lu ZGV4IChpbmRleG9pZD0yNjYyLCBoZWFwb2lkPTEyNTkpCmF0IHJlbGNhY2hlLmM6NDE0Ng0KIzE0 IDB4MDAwMDU1YjkxOWQ0MjNlZSBpbiBSZWxhdGlvbkNhY2hlSW5pdGlhbGl6ZVBoYXNlMyAoKSBh dApyZWxjYWNoZS5jOjM5MDANCiMxNSAweDAwMDA1NWI5MTlkNjg2NDAgaW4gSW5pdFBvc3RncmVz IChpbl9kYm5hbWU9MHg1NWI5MWI2MTVjNTAgImNvbmV0ZGIiLApkYm9pZD0wLCB1c2VybmFtZT0w eDU1YjkxYjYxNWMzOCAicm9vdCIsIHVzZXJvaWQ9MCwgb3V0X2RibmFtZT0weDAsCm92ZXJyaWRl X2FsbG93X2Nvbm5lY3Rpb25zPWZhbHNlKSBhdCBwb3N0aW5pdC5jOjEwMzUNCiMxNiAweDAwMDA1 NWI5MTliYzc3NjEgaW4gUG9zdGdyZXNNYWluIChhcmdjPTEsIGFyZ3Y9MHg1NWI5MWI2MTVkYjAs CmRibmFtZT0weDU1YjkxYjYxNWM1MCAiY29uZXRkYiIsIHVzZXJuYW1lPTB4NTViOTFiNjE1YzM4 ICJyb290IikgYXQKcG9zdGdyZXMuYzozOTE3DQojMTcgMHgwMDAwNTViOTE5YjFmNGRiIGluIEJh Y2tlbmRSdW4gKHBvcnQ9MHg1NWI5MWI2MWJhYjApIGF0CnBvc3RtYXN0ZXIuYzo0NTIxDQojMTgg MHgwMDAwNTViOTE5YjFlYmRmIGluIEJhY2tlbmRTdGFydHVwIChwb3J0PTB4NTViOTFiNjFiYWIw KSBhdApwb3N0bWFzdGVyLmM6NDIwNA0KIzE5IDB4MDAwMDU1YjkxOWIxYWU1MCBpbiBTZXJ2ZXJM b29wICgpIGF0IHBvc3RtYXN0ZXIuYzoxNzI5DQojMjAgMHgwMDAwNTViOTE5YjFhNWZmIGluIFBv c3RtYXN0ZXJNYWluIChhcmdjPTEsIGFyZ3Y9MHg1NWI5MWI1ZTIxZDApIGF0CnBvc3RtYXN0ZXIu YzoxNDAyDQojMjEgMHgwMDAwNTViOTE5YTNiZTM3IGluIG1haW4gKGFyZ2M9MSwgYXJndj0weDU1 YjkxYjVlMjFkMCkgYXQgbWFpbi5jOjIyOA0KDQpBZnRlciBhbmFseXNpcywgaXQgaXMgY29uZmly bWVkIHRoYXQgdGhlIHJlbGNhY2hlIG5lZWRzIHRvIGJlIGNvbnN0cnVjdGVkCmZvciBuZXcgY29u bmVjdGlvbnMuIA0KUmVsYXRpb25CdWlsZERlc2MgbmVlZHMgdG8gc2NhbiB0aGUgcGdfYXR0cmli dXRlIHRhYmxlIGluIHNlcXVlbmNlIHRvIGxvYWQKdGhlIGNyaXRpY2FsIGluZGV4LiANCkhvd2V2 ZXIsIHRoZSBpbmRleGVzIG9mIHRoZSBzeXN0ZW0gdGFibGVzIGJlaW5nIGxvYWRlZCBhcmUgbW92 ZWQgdG8gdGhlIGVuZApvZiB0aGUgZmlsZS4gDQpTbyB0aGUgZW50aXJlIHBnX2F0dHJpYnV0ZSBu ZWVkcyB0byBiZSBsb2FkZWQsIHdoZXJlYXMgYmVmb3JlIG9ubHkgYSBmZXcKcGFnZXMgaGFkIHRv IGJlIHNjYW5uZWQuDQoNCnRlc3Q9PiBzZWxlY3QgY3RpZCwgYXR0cmVsaWQsIGF0dG5hbWUsYXR0 bnVtIGZyb20gcGdfYXR0cmlidXRlIHdoZXJlCmF0dHJlbGlkIGluICgncGdfY2xhc3Nfb2lkX2lu ZGV4Jzo6cmVnY2xhc3MsCidwZ19hdHRyaWJ1dGVfcmVsaWRfYXR0bnVtX2luZGV4Jzo6cmVnY2xh c3MsCidwZ19pbmRleF9pbmRleHJlbGlkX2luZGV4Jzo6cmVnY2xhc3MsICdwZ19vcGNsYXNzX29p ZF9pbmRleCc6OnJlZ2NsYXNzLAoncGdfYW1wcm9jX2ZhbV9wcm9jX2luZGV4Jzo6cmVnY2xhc3Ms CidwZ19yZXdyaXRlX3JlbF9ydWxlbmFtZV9pbmRleCc6OnJlZ2NsYXNzLAoncGdfdHJpZ2dlcl90 Z3JlbGlkX3RnbmFtZV9pbmRleCc6OnJlZ2NsYXNzKTsNCiAgICAgY3RpZCAgICAgfCBhdHRyZWxp ZCB8ICAgICBhdHRuYW1lICAgICB8IGF0dG51bSANCi0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0NCiAoMjA0MDkwOCwzNykgfCAgICAgMjY1NSB8IGFt cHJvY2ZhbWlseSAgICB8ICAgICAgMQ0KICgyMDQwOTA4LDM4KSB8ICAgICAyNjU1IHwgYW1wcm9j bGVmdHR5cGUgIHwgICAgICAyDQogKDIwNDA5MDgsMzkpIHwgICAgIDI2NTUgfCBhbXByb2NyaWdo dHR5cGUgfCAgICAgIDMNCiAoMjA0MDkwOCw0MCkgfCAgICAgMjY1NSB8IGFtcHJvY251bSAgICAg ICB8ICAgICAgNA0KICgyMDQwOTA4LDQ3KSB8ICAgICAyNjU5IHwgYXR0cmVsaWQgICAgICAgIHwg ICAgICAxDQogKDIwNDA5MDgsNDgpIHwgICAgIDI2NTkgfCBhdHRudW0gICAgICAgICAgfCAgICAg IDINCiAoMjA0MDkwOSwzKSAgfCAgICAgMjY2MiB8IG9pZCAgICAgICAgICAgICB8ICAgICAgMQ0K ICgyMDQwOTA5LDQ2KSB8ICAgICAyNjc5IHwgaW5kZXhyZWxpZCAgICAgIHwgICAgICAxDQogKDIw NDA5MTAsOCkgIHwgICAgIDI2ODcgfCBvaWQgICAgICAgICAgICAgfCAgICAgIDENCiAoMjA0MDkx MCwyNCkgfCAgICAgMjY5MyB8IGV2X2NsYXNzICAgICAgICB8ICAgICAgMQ0KICgyMDQwOTEwLDI1 KSB8ICAgICAyNjkzIHwgcnVsZW5hbWUgICAgICAgIHwgICAgICAyDQogKDIwNDA5MTAsNDcpIHwg ICAgIDI3MDEgfCB0Z3JlbGlkICAgICAgICAgfCAgICAgIDENCiAoMjA0MDkxMCw0OCkgfCAgICAg MjcwMSB8IHRnbmFtZSAgICAgICAgICB8ICAgICAgMg0KKDEzIHJvd3MpDQoNClNvIEkgd29uZGVy IGlmIGl0J3MgbmVjZXNzYXJ5IHRvIG9wdGltaXplIHRoZSB2YWN1dW0gZnVsbCBzeXN0ZW0gdGFi bGUgdG8KY3Vsc3RlciBhY3Rpb24gYnkgZGVmYXVsdC4KCg== --===============7284593249100933101==--