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 1rmytR-00AxVv-JS for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Mar 2024 16:34:22 +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 1rmytQ-006Ima-2b for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Mar 2024 16:34:20 +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 1rmwxG-005RhT-GL for pgsql-bugs@lists.postgresql.org; Wed, 20 Mar 2024 14:30: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 1rmwxD-005YjI-7c for pgsql-bugs@lists.postgresql.org; Wed, 20 Mar 2024 14:30: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=jcxBwbofJIykCCLW3PBTnXcfIvFZyTB1eRyuxtGhqkw=; b=bjprSPPr3u9s5ePFIyDgEFt0oY LhxtbmNG8Rm35rpVur9pfgsplm+TflFO9/rwFmZlNaw7uUrbRoSSKeSVjkSJJz5/Z11EiRyqO/KAr C84KMtjsosM3nXBFz5LBPEDD7UCjWBCKN7bwmdwH/WTwqXHggQk8tGbP54Sr+nTNsLacq1pHBZ5ov G5ufVUq35hcJhKU2Ex83A2Q9YyZGdrWRFiLxg+ZYUsWaLgFVrFOzVJiwtC4YIpPS4WdfUq7WJdUwb jvHkjJo2STDhJE8dMNpUnK4uDBIuk/UYxnTf1UUA3kVvSDPV8pwvY9dkm/WWnjxhfdM8YzTWNNa+Y KjM/yEuQ==; 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 1rmwxA-00F6KA-NT for pgsql-bugs@lists.postgresql.org; Wed, 20 Mar 2024 14:30: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 1rmwx8-003Xgj-E7 for pgsql-bugs@lists.postgresql.org; Wed, 20 Mar 2024 14:30:03 +0000 Content-Type: multipart/mixed; boundary="===============1037405965528769876==" MIME-Version: 1.0 Subject: BUG #18402: Attaching a new partition doesn't reuse the prebuilt index on said partition To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gparc@online.fr Reply-To: gparc@online.fr, pgsql-bugs@lists.postgresql.org Date: Wed, 20 Mar 2024 14:29:14 +0000 Message-ID: <18402-23452305346476d6@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 --===============1037405965528769876== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQwMgpMb2dnZWQgYnk6ICAgICAgICAgIEdpbGxlcyBQQVJDCkVtYWls IGFkZHJlc3M6ICAgICAgZ3BhcmNAb25saW5lLmZyClBvc3RncmVTUUwgdmVyc2lvbjogMTYuMgpP cGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpFeGFtcGxlIDoN Cg0KRmlyc3QgSSBjcmVhdGUgYSBsaXN0IHBhcnRpdGlvbmVkIHRhYmxlIGFuZCBmaWxsIGl0DQpD UkVBVEUgVEFCTEUgbWFzdGVyDQooDQppZCBpbnRlZ2VyIE5PVCBOVUxMLA0KbWlsbGVzaW1lIHZh cmNoYXIoNCkgTk9UIE5VTEwsDQpDT05TVFJBSU5UIG1hc3Rlcl9wayBQUklNQVJZIEtFWSAoaWQs IG1pbGxlc2ltZSkNCikgcGFydGl0aW9uIGJ5IGxpc3QgKG1pbGxlc2ltZSk7DQoNCkNSRUFURSBU QUJMRSBtYXN0ZXJfMjAyMiBQQVJUSVRJT04gT0YgbWFzdGVyIEZPUiBWQUxVRVMgSU4gKCcyMDIy Jyk7DQpDUkVBVEUgVEFCTEUgbWFzdGVyXzIwMjMgUEFSVElUSU9OIE9GIG1hc3RlciBGT1IgVkFM VUVTIElOICgnMjAyMycpOw0KQ1JFQVRFIFRBQkxFIG1hc3Rlcl8yMDI0IFBBUlRJVElPTiBPRiBt YXN0ZXIgRk9SIFZBTFVFUyBJTiAoJzIwMjQnKTsNCkNSRUFURSBUQUJMRSBtYXN0ZXJfMjAyNSBQ QVJUSVRJT04gT0YgbWFzdGVyIEZPUiBWQUxVRVMgSU4gKCcyMDI1Jyk7DQoNCkRPDQokZG8kDQpC RUdJTiANCiAgIEZPUiBpIElOIDIwMjIuLjIwMjUgTE9PUA0KICAgICAgSU5TRVJUIElOVE8gbWFz dGVyIFZBTFVFUyAoZ2VuZXJhdGVfc2VyaWVzKDEsMTAwMDAwKSwgaTo6dmFyY2hhcik7DQogICBF TkQgTE9PUDsNCkVORA0KJGRvJDsNCg0KSSBub3cgbGlzdCB0aGUgY3JlYXRlZCBpbmRleGVzOg0K XGRpUysgbWFzdGVyKg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgTGlzdCBvZiByZWxhdGlvbnMNCiBTY2hlbWEgfCAgICAgICBOYW1lICAgICAg IHwgICAgICAgVHlwZSAgICAgICAgfCAgT3duZXIgICB8ICAgIFRhYmxlICAgIHwKUGVyc2lzdGVu Y2UgfCBBY2Nlc3MgbWV0aG9kIHwgIFNpemUgICB8IERlc2NyaXB0aW9uIA0KLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0t DQogcHVibGljIHwgbWFzdGVyXzIwMjJfcGtleSB8IGluZGV4ICAgICAgICAgICAgIHwgcG9zdGdy ZXMgfCBtYXN0ZXJfMjAyMiB8CnBlcm1hbmVudCAgIHwgYnRyZWUgICAgICAgICB8IDMwODgga0Ig fCANCiBwdWJsaWMgfCBtYXN0ZXJfMjAyM19wa2V5IHwgaW5kZXggICAgICAgICAgICAgfCBwb3N0 Z3JlcyB8IG1hc3Rlcl8yMDIzIHwKcGVybWFuZW50ICAgfCBidHJlZSAgICAgICAgIHwgMzA4OCBr QiB8IA0KIHB1YmxpYyB8IG1hc3Rlcl8yMDI0X3BrZXkgfCBpbmRleCAgICAgICAgICAgICB8IHBv c3RncmVzIHwgbWFzdGVyXzIwMjQgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAzMDg4 IGtCIHwgDQogcHVibGljIHwgbWFzdGVyXzIwMjVfcGtleSB8IGluZGV4ICAgICAgICAgICAgIHwg cG9zdGdyZXMgfCBtYXN0ZXJfMjAyNSB8CnBlcm1hbmVudCAgIHwgYnRyZWUgICAgICAgICB8IDMw ODgga0IgfCANCiBwdWJsaWMgfCBtYXN0ZXJfcGsgICAgICAgIHwgcGFydGl0aW9uZWQgaW5kZXgg fCBwb3N0Z3JlcyB8IG1hc3RlciAgICAgIHwKcGVybWFuZW50ICAgfCBidHJlZSAgICAgICAgIHwg MCBieXRlcyB8IA0KKDUgcm93cykNCg0KDQpOb3cgSSBwcmVwYXJlIGEgbmV3IDIwMjYgcGFydGl0 aW9uIHdpdGggY29ycmVjdCBjb25zdHJhaW50cyBhbmQgaW5kZXhlcyBhbmQKYXR0YWNoIGl0IDoN Cg0KQ1JFQVRFIFRBQkxFIG1hc3Rlcl8yMDI2IChMSUtFIG1hc3RlciBJTkNMVURJTkcgREVGQVVM VFMgSU5DTFVESU5HCkNPTlNUUkFJTlRTKTsNCkFMVEVSIFRBQkxFIG1hc3Rlcl8yMDI2IEFERCBD T05TVFJBSU5UIG1hc3Rlcl8yMDI2X2NrIENIRUNLIChtaWxsZXNpbWUgPQonMjAyNicpOw0KRE8g DQokZG8kDQpCRUdJTg0KICAgICAgSU5TRVJUIElOVE8gbWFzdGVyXzIwMjYgVkFMVUVTIChnZW5l cmF0ZV9zZXJpZXMoMSwxMDAwMDApLCAnMjAyNicpOw0KRU5EDQokZG8kOw0KQ1JFQVRFIFVOSVFV RSBJTkRFWCBDT05DVVJSRU5UTFkgbWFzdGVyXzIwMjZfcGtleSBPTiBtYXN0ZXJfMjAyNiAoaWQs Cm1pbGxlc2ltZSk7DQpBTFRFUiBUQUJMRSBtYXN0ZXIgQVRUQUNIIFBBUlRJVElPTiBtYXN0ZXJf MjAyNiBGT1IgVkFMVUVTIElOICgnMjAyNicpOw0KQUxURVIgVEFCTEUgbWFzdGVyXzIwMjYgRFJP UCBDT05TVFJBSU5UIG1hc3Rlcl8yMDI2X2NrOyANCg0KQnV0IG5vdywgd2hlbiBJIGxpc3QgdGhl IGluZGV4ZXMgYWdhaW4sIEkgc2VlIHRoYXQgbXkgdW5pcXVlIGluZGV4IGFib3ZlIGlzCm5vdCBj b25zaWRlcmVkIHRvIHVzZQ0KYW5kIGEgbmV3IG9uZSBpcyBjcmVhdGVkIChtYXN0ZXJfMjAyNl9w a2V5MSkuDQpcZGlTKyBtYXN0ZXIqDQogU2NoZW1hIHwgICAgICAgTmFtZSAgICAgICAgfCAgICAg ICBUeXBlICAgICAgICB8ICBPd25lciAgIHwgICAgVGFibGUgICAgfApQZXJzaXN0ZW5jZSB8IEFj Y2VzcyBtZXRob2QgfCAgU2l6ZSAgIHwgRGVzY3JpcHRpb24gDQotLS0tLS0tLSstLS0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQogcHVi bGljIHwgbWFzdGVyXzIwMjJfcGtleSAgfCBpbmRleCAgICAgICAgICAgICB8IHBvc3RncmVzIHwg bWFzdGVyXzIwMjIgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAzMDg4IGtCIHwgDQog cHVibGljIHwgbWFzdGVyXzIwMjNfcGtleSAgfCBpbmRleCAgICAgICAgICAgICB8IHBvc3RncmVz IHwgbWFzdGVyXzIwMjMgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAzMDg4IGtCIHwg DQogcHVibGljIHwgbWFzdGVyXzIwMjRfcGtleSAgfCBpbmRleCAgICAgICAgICAgICB8IHBvc3Rn cmVzIHwgbWFzdGVyXzIwMjQgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAzMDg4IGtC IHwgDQogcHVibGljIHwgbWFzdGVyXzIwMjVfcGtleSAgfCBpbmRleCAgICAgICAgICAgICB8IHBv c3RncmVzIHwgbWFzdGVyXzIwMjUgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAzMDg4 IGtCIHwgDQogcHVibGljIHwgbWFzdGVyXzIwMjZfcGtleSAgfCBpbmRleCAgICAgICAgICAgICB8 IHBvc3RncmVzIHwgbWFzdGVyXzIwMjYgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAgfCAz MTA0IGtCIHwgDQogcHVibGljIHwgbWFzdGVyXzIwMjZfcGtleTEgfCBpbmRleCAgICAgICAgICAg ICB8IHBvc3RncmVzIHwgbWFzdGVyXzIwMjYgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAgICAg fCAzMTA0IGtCIHwgDQogcHVibGljIHwgbWFzdGVyX3BrICAgICAgICAgfCBwYXJ0aXRpb25lZCBp bmRleCB8IHBvc3RncmVzIHwgbWFzdGVyICAgICAgfApwZXJtYW5lbnQgICB8IGJ0cmVlICAgICAg ICAgfCAwIGJ5dGVzIHwgDQooNyByb3dzKQ0KDQp3aHkgaXMgaXQgc28gPw0KDQpCdWcgb3IgRmVh dHVyZSA/DQpSZWdhcmRzDQpHaWxsZXMKCg== --===============1037405965528769876==--