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 1l81R9-0006L8-DL for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Feb 2021 13:46:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l81R7-0002yA-An for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Feb 2021 13:46:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7ybr-0006e9-8l for pgsql-bugs@lists.postgresql.org; Fri, 05 Feb 2021 10:45:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7ybp-0008Du-Ki for pgsql-bugs@lists.postgresql.org; Fri, 05 Feb 2021 10:45: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=hxTMF+K3t00g+Ajpg8zxBCTxicjE0uQNvnkDHGmX0jo=; b=jMdzKDxlsvg9HbjUh+OtgvSMu3 kW4/akclMRchCNjvphK5vhmvS3Tdkryb8bNZ3y8YohqIRVJWKOsjZIP9FXvn1Q704N52Fz+DiUFAu kc2boHl7Y/fgfteSzeYSTRXZot/weZr7THAuUrT7o26+Wx0T1ln+vuPQSvYTRp3W4A3AriLZ1BCr8 vcn5TIxxxvNmFPw61NG05zb59AQ5Pc1U3CLi1LvAfelXpueRbHTTZiMqkxH3cs1g7pU4DWwwM9kFv EAiA7KttX1m4In1AMToOLpsa2RdWrEtx/mo9NVJZVkIkQRjzRGj+R/B6xmdaIDD/xkea53zgT82Su AVm4uTkQ==; 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 1l7ybo-0008Eg-19 for pgsql-bugs@lists.postgresql.org; Fri, 05 Feb 2021 10:45:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l7ybm-0004JU-Kz for pgsql-bugs@lists.postgresql.org; Fri, 05 Feb 2021 10:45:02 +0000 Content-Type: multipart/mixed; boundary="===============3062922818487346962==" MIME-Version: 1.0 Subject: BUG #16855: No partition pruning when using partitions with custom hash function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stanislaw.skonieczny@gmail.com Reply-To: stanislaw.skonieczny@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 05 Feb 2021 10:44:32 +0000 Message-ID: <16855-32d2983ea6e6b208@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3062922818487346962== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg1NQpMb2dnZWQgYnk6ICAgICAgICAgIFN0YW5pc8WCYXcgU2tvbmll Y3pueQpFbWFpbCBhZGRyZXNzOiAgICAgIHN0YW5pc2xhdy5za29uaWVjem55QGdtYWlsLmNvbQpQ b3N0Z3JlU1FMIHZlcnNpb246IDEzLjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTMuMS0x LnBnZGcxOC4wNCsxCkRlc2NyaXB0aW9uOiAgICAgICAgCgpTZWUgdGhpcyBleGFtcGxlLg0KDQpz aG93IGVuYWJsZV9wYXJ0aXRpb25fcHJ1bmluZzsNCi0tICBlbmFibGVfcGFydGl0aW9uX3BydW5p bmcNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQotLSAgb24NCi0tICgxIHJvdykNCg0K Q1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcGFydGl0aW9uX2N1c3RvbV9iaWdpbnRfaGFzaCh2 YWx1ZSBCSUdJTlQsIHNlZWQKQklHSU5UKQ0KUkVUVVJOUyBCSUdJTlQgQVMgJCQNCiAgICBTRUxF Q1QgdmFsdWU7DQokJCBMQU5HVUFHRSBTUUwgSU1NVVRBQkxFIFBBUkFMTEVMIFNBRkU7DQotLSBD UkVBVEUgRlVOQ1RJT04NCg0KQ1JFQVRFIE9QRVJBVE9SIENMQVNTIHBhcnRpdGlvbl9jdXN0b21f YmlnaW50X2hhc2hfb3ANCiAgICBGT1IgVFlQRSBpbnQ4DQogICAgVVNJTkcgaGFzaCBBUw0KICAg IE9QRVJBVE9SIDEgPSwNCiAgICBGVU5DVElPTiAyIHBhcnRpdGlvbl9jdXN0b21fYmlnaW50X2hh c2goQklHSU5ULCBCSUdJTlQpOw0KLS0gQ1JFQVRFIE9QRVJBVE9SIENMQVNTDQoNCmNyZWF0ZSB0 YWJsZSBzYW1wbGUocGFydF9pZCBiaWdpbnQpIHBhcnRpdGlvbiBieSBoYXNoKHBhcnRfaWQKcGFy dGl0aW9uX2N1c3RvbV9iaWdpbnRfaGFzaF9vcCk7DQotLSBDUkVBVEUgVEFCTEUNCg0KY3JlYXRl IHRhYmxlIHNhbXBsZV9wYXJ0XzEgcGFydGl0aW9uIG9mIHNhbXBsZSBmb3IgdmFsdWVzIHdpdGgg KG1vZHVsdXMgMywKcmVtYWluZGVyIDApOw0KLS0gQ1JFQVRFIFRBQkxFDQoNCmNyZWF0ZSB0YWJs ZSBzYW1wbGVfcGFydF8yIHBhcnRpdGlvbiBvZiBzYW1wbGUgZm9yIHZhbHVlcyB3aXRoIChtb2R1 bHVzIDMsCnJlbWFpbmRlciAxKTsNCi0tIENSRUFURSBUQUJMRQ0KDQpjcmVhdGUgdGFibGUgc2Ft cGxlX3BhcnRfMyBwYXJ0aXRpb24gb2Ygc2FtcGxlIGZvciB2YWx1ZXMgd2l0aCAobW9kdWx1cyAz LApyZW1haW5kZXIgMik7DQotLSBDUkVBVEUgVEFCTEUNCg0KXGQrIHNhbXBsZTsNCi0tICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBQYXJ0aXRpb25lZCB0YWJsZSAicHVibGljLnNhbXBsZSIN Ci0tICBDb2x1bW4gIHwgIFR5cGUgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwg U3RvcmFnZSB8IFN0YXRzCnRhcmdldCB8IERlc2NyaXB0aW9uDQotLQotLS0tLS0tLS0rLS0tLS0t LS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0NCi0tICBwYXJ0X2lkIHwgYmlnaW50IHwgICAgICAgICAgIHwgICAg ICAgICAgfCAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAKICB8DQotLSBQYXJ0aXRpb24g a2V5OiBIQVNIIChwYXJ0X2lkIHBhcnRpdGlvbl9jdXN0b21fYmlnaW50X2hhc2hfb3ApDQotLSBQ YXJ0aXRpb25zOiBzYW1wbGVfcGFydF8xIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzLCByZW1h aW5kZXIgMCksDQotLSAgICAgICAgICAgICBzYW1wbGVfcGFydF8yIEZPUiBWQUxVRVMgV0lUSCAo bW9kdWx1cyAzLCByZW1haW5kZXIgMSksDQotLSAgICAgICAgICAgICBzYW1wbGVfcGFydF8zIEZP UiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzLCByZW1haW5kZXIgMikNCg0KZXhwbGFpbiBzZWxlY3Qg KiBmcm9tIHNhbXBsZSB3aGVyZSBwYXJ0X2lkID0gMTsNCi0tICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFODQotLQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0tICBB cHBlbmQgIChjb3N0PTAuMDAuLjEwMS4zNiByb3dzPTMzIHdpZHRoPTgpDQotLSAgICAtPiAgU2Vx IFNjYW4gb24gc2FtcGxlX3BhcnRfMSBzYW1wbGVfMSAgKGNvc3Q9MC4wMC4uMzMuNzMgcm93cz0x MQp3aWR0aD04KQ0KLS0gICAgICAgICAgRmlsdGVyOiAocGFydF9pZCA9IDEpDQotLSAgICAtPiAg U2VxIFNjYW4gb24gc2FtcGxlX3BhcnRfMiBzYW1wbGVfMiAgKGNvc3Q9MC4wMC4uMzMuNzMgcm93 cz0xMQp3aWR0aD04KQ0KLS0gICAgICAgICAgRmlsdGVyOiAocGFydF9pZCA9IDEpDQotLSAgICAt PiAgU2VxIFNjYW4gb24gc2FtcGxlX3BhcnRfMyBzYW1wbGVfMyAgKGNvc3Q9MC4wMC4uMzMuNzMg cm93cz0xMQp3aWR0aD04KQ0KLS0gICAgICAgICAgRmlsdGVyOiAocGFydF9pZCA9IDEpDQotLSAo NyByb3dzKQ0KDQpJJ2QgZXhwZWN0IHRoYXQgb25seSBvbmUgcGFydGl0aW9uIHdpbGwgYmUgc2Nh bm5lZCwgb3RoZXIgMiB3aWxsIGJlIHJlbW92ZWQKYnkgcGFydGl0aW9uIHBydW5pbmcuDQpFeGFt cGxlIGFib3ZlIHdvcmtzIGFzIGV4cGVjdGVkIHdoZW4gSSByZW1vdmUgY3VzdG9tIGhhc2ggZnVu Y3Rpb24uCgo= --===============3062922818487346962==--