Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3EqT-0005Dr-LB for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Dec 2022 11:13:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3EqS-0002iB-HA for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Dec 2022 11:13:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3CTn-0002dz-U0 for pgsql-bugs@lists.postgresql.org; Thu, 08 Dec 2022 08:42:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3CTl-0003Es-Rq for pgsql-bugs@lists.postgresql.org; Thu, 08 Dec 2022 08:42:06 +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=Tm4YgN1Z31Q3+2bGtB8vueXgzRZLXB5h1j8GCLaz0Do=; b=UHaLi2DPT/DZ3QPZF4G7orIJ2x NW+Y2NOVNUlR/75ocq2yPVVfRvkFIZuTIOOIcqFDAWijQZJz8iboM+kLBl0I63pmMsq8Kws3cXEV8 g04xNrrlhw2ZrsFUxnJgFoZtTKaThty0Xd//69jnEX1nAiY0SRedGjO9m37xgF58n4vRRxx0Uylwk EB5k5VCLDwqf2WCMRLZttLR2xOFPFD3OkyVEcsV8UiTKdf5yeJUQ6gX25VqASAUdWIEZozRJ+SW+3 ZiOOw3L5TFDdTwt58N/izQRYB56Ue9eE0/M0Mg7x2VFHDxL7K8OzseJySAL14yip9WkCW5wAQl8ae m1xzFhEQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3CTl-0001w0-Fw for pgsql-bugs@lists.postgresql.org; Thu, 08 Dec 2022 08:42: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 1p3CTi-00AJhA-Fc for pgsql-bugs@lists.postgresql.org; Thu, 08 Dec 2022 08:42:02 +0000 Content-Type: multipart/mixed; boundary="===============5899661800445612554==" MIME-Version: 1.0 Subject: BUG #17707: Foreign key verification is very slow while creating empty partitions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: harshppt75@gmail.com Reply-To: harshppt75@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 08 Dec 2022 08:41:30 +0000 Message-ID: <17707-b7aba5bf7d09b73c@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 --===============5899661800445612554== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcwNwpMb2dnZWQgYnk6ICAgICAgICAgIGhhcnNoIGt1bWFyCkVtYWls IGFkZHJlc3M6ICAgICAgaGFyc2hwcHQ3NUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx NS4xCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCkkgYW0g dXNpbmcgcG9zdGdyZXMgMTQgYW5kIGRlYWxpbmcgd2l0aCBtdWx0aS1sZXZlbCBwYXJ0aXRpb25p bmcuIEFuIHNhbXBsZQp0YWJsZSBkZXNpZ24gbG9va3MgbGlrZSA6IA0KVGFibGUgQSA6DQpDUkVB VEUgVEFCTEUgaXNzdWUgKA0KaWQgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYmlnc2Vy aWFsLA0KY2F0YWxvZ19pZCAgICAgICAgICAgICAgICAgICAgICAgYmlnaW50ICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgTk9UIE5VTEwsDQpzdWJtaXRfdGltZSAg ICAgICAgICAgICAgICAgICAgICB0aW1lc3RhbXAgV0lUSCBUSU1FIFpPTkUgICAgICAgICAgICAg ICAgICAgCiAgICAgICBOT1QgTlVMTCwNClBSSU1BUlkgS0VZIChpZCwgY2F0YWxvZ19pZCwgc3Vi bWl0X3RpbWUpDQopIFBBUlRJVElPTiBCWSBMSVNUIChjYXRhbG9nX2lkKQ0KDQpUYWJsZSBCIDoN CkNSRUFURSBUQUJMRSBpc3N1ZV9kZXRhaWwgKA0KaWQgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgYmlnc2VyaWFsLA0KY2F0YWxvZ19pZCAgICAgICAgICAgICAgICAgICAgICAgYmlnaW50 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgTk9UIE5VTEwsDQpp c3N1ZV9pZCAgICAgICAgICAgICAgICAgICAgICAgICBiaWdpbnQgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgCiAgICAgICBOT1QgTlVMTCwNCnN1Ym1pdF90aW1lICAgICAgICAg ICAgICAgICAgICAgIHRpbWVzdGFtcCBXSVRIIFRJTUUgWk9ORSAgICAgICAgICAgICAgICAgICAK ICAgICAgIE5PVCBOVUxMLA0KUFJJTUFSWSBLRVkgKGlkLCBjYXRhbG9nX2lkLCBzdWJtaXRfdGlt ZSksDQpGT1JFSUdOIEtFWSAoY2F0YWxvZ19pZCwgc3VibWl0X3RpbWUsIGlzc3VlX2lkKSBSRUZF UkVOQ0VTIGlzc3VlCihjYXRhbG9nX2lkLCBzdWJtaXRfdGltZSwgaWQpDQopIFBBUlRJVElPTiBC WSBMSVNUIChjYXRhbG9nX2lkKQ0KDQoNClNvIHBhcnRpdGlvbiBrZXkgZm9yIGZpcnN0IGxldmVs IGlzIGNhdGFsb2dfaWQocGFydGl0aW9uIGJ5IGxpc3QpIGFuZCBmb3IKc2Vjb25kIGxldmVsIGlz IHN1Ym1pdF90aW1lKHBhcnRpdGlvbiBieSByYW5nZSAtIG9uIHdlZWtseSBiYXNpcykuDQoNClNl Y29uZCBsZXZlbCBwYXJ0aXRpb25pbmcgZGVmaW5pdGlvbiA6DQpGb3IgVGFibGUgQSA6IA0KYGBg DQpDUkVBVEUgVEFCTEUgaXNzdWVfY2F0YWxvZzEgUEFSVElUSU9OIE9GIGlzc3VlIEZPUiBWQUxV RVMgSU4gKDEpIFBBUlRJVElPTgpCWSBSQU5HRSAoc3VibWl0X3RpbWUpDQpgYGANCg0KRm9yIFRh YmxlIEIgOiANCmBgYA0KQ1JFQVRFIFRBQkxFIGlzc3VlX2RldGFpbF9jYXRhbG9nMSBQQVJUSVRJ T04gT0YgaXNzdWVfZGV0YWlsIEZPUiBWQUxVRVMgSU4KKDEpIFBBUlRJVElPTiBCWSBSQU5HRSAo c3VibWl0X3RpbWUpDQpgYGANCg0KU2ltaWxhcmx5LCBjaGlsZCBwYXJ0aXRpb25zIGFyZSBjcmVh dGVkIGJ5IHJhbmdlIGFuZCBvbiB3ZWVrbHkgYmFzaXMgZm9yCnBhc3QgMyB5ZWFycy4gDQpGaXJz dCBsZXZlbCBwYXJ0aXRpb25lZCB0YWJsZSBpcyBjcmVhdGVkIGluY2xlbWVudGx5LCBpZSwgZmly c3QgZm9yCmNhdGFsb2dfaWQgPSAxLCBmaXJzdCBsZXZlbCBwYXJ0aXRpb25lZCB0YWJsZSBpcyBj cmVhdGVkIGFuZCB0aGVuIGl0J3MKcGFydGl0aW9ucyBhcmUgY3JlYXRlZCB0aGVuIGZvciBjYXRh bG9nX2lkID0gMiBhbmQgc28gb24uIFNvLCBmb3IKY2F0YWxvZ19pZD0xIHRoZXJlIHdvdWxkIGJl IGFyb3VuZCAxNjYgcGFydGl0aW9ucyAocmFuZ2UgcGFydGl0aW9uIC0KcGFydGl0aW9uZWQgYnkg d2Vla2x5IGZvciBwYXN0IDMgeWVhcikuIFNpbWlsYXIgZm9yIG90aGVyIGNvbnNlY3V0aXZlCmNh dGFsb2dfaWQsIDE2NiBwYXJ0aXRpb25zIHdvdWxkIGJlIGNyZWF0ZWQuDQoNCg0KV2hpbGUgZGVm aW5pbmcgdGhlIHBhcnRpdGlvbnMsIHRoZSB0aW1lIHRvIGNyZWF0ZSBlbXB0eSBwYXJ0aXRpb25z IGluIGNhc2UKb2YgYGBgaXNzdWVfZGV0YWlsYGBgIHRhYmxlIHN0YXJ0IGdyb3dpbmcobmVhcmx5 IGJ5IDMwLTUwICUgaW5jcmVhc2UgYmV0d2Vlbgpjb25zZWN1dGl2ZSBjYXRhbG9nX2lkKS4gQWZ0 ZXIgbG9va2luZyBhdCBwb3N0Z3JlcyBzZXJ2ZXIgbG9nLCBJIGZvdW5kIHRoYXQKZm9yZWlnbiBr ZXkgcmVmZXJlbnRpYWwgY29uc3RyYWludCB2ZXJpZmljYXRpb24gaXMgdGFraW5nIHRpbWUuIFRo ZW4sIHRvCmRvdWJsZSBjaGVjayBJIGNyZWF0ZWQgZW1wdHkgcGFydGl0aW9uIGNyZWF0aW9uIHRp bWUgd2l0aG91dCBmb3JlaWduIGtleSwgaW4KdGhhdCBjYXNlIGl0IHdhcyB2ZXJ5IGZhc3Qod2l0 aGluIGNvdXBsZSBvZiBzZWNvbmQpLg0KDQpJdCdzIHZlcnkgd2VpcmQgdGhhdCBjcmVhdGluZyBl bXB0eSBwYXJ0aXRpb24gZm9yIGlzc3VlX2RldGFpbCBpcyB0YWtpbmcKbW9yZSB0aGFuIDEwIG1p bnV0ZXMgYWZ0ZXIgY2F0YWxvZ19pZCA9IDQwLiBIb3cgY2FuIGVtcHR5IHBhcnRpdGlvbnMKY3Jl YXRpb24gdGFrZSB0aGF0IG11Y2ggdGltZS4gV2h5IGZvcmVpZ24ga2V5IGludGVncml0eSB2ZXJp ZmljYXRpb24gaXMgdGhhdApzbG93IG9uIGVtcHR5IHRhYmxlID8KCg== --===============5899661800445612554==--