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 1kkTNF-0006In-Ta for pgsql-sql@arkaria.postgresql.org; Wed, 02 Dec 2020 14:44:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkTNE-0003gN-J0 for pgsql-sql@arkaria.postgresql.org; Wed, 02 Dec 2020 14:44:52 +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 1kkTNE-0003gG-94 for pgsql-sql@lists.postgresql.org; Wed, 02 Dec 2020 14:44:52 +0000 Received: from forward500p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:110]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkTN7-000334-Bv for pgsql-sql@postgresql.org; Wed, 02 Dec 2020 14:44:51 +0000 Received: from mxback21j.mail.yandex.net (mxback21j.mail.yandex.net [IPv6:2a02:6b8:c04:242:0:640:ab5f:bc75]) by forward500p.mail.yandex.net (Yandex) with ESMTP id 35D799400D7; Wed, 2 Dec 2020 17:44:44 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback21j.mail.yandex.net (mxback/Yandex) with ESMTP id bnlXT9dBYc-ihfmxWdQ; Wed, 02 Dec 2020 17:44:43 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1606920283; bh=uZNiXuqdOLOLbjYTLS1IkWdI92XZ8Mg6BjqVHSpHD+w=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=sVD/h72UzxyZfAg8GezomzDzTkw/+jGEYtaWC4r945fk1tX65l7I05AJORRR0z0yt J22ZkODSI5CQM1IDlLaOTM1eibi7e+ftiB4eP3uEOHDxnJNOp/ye3w2PsBaHWGpOUA 7pVR3e95FjsQQvR2U07uRz1DmgZ2K7wfldSUdrac= Authentication-Results: mxback21j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by sas2-6d8463dc3f95.qloud-c.yandex.net with HTTP; Wed, 02 Dec 2020 17:44:43 +0300 From: Samed YILDIRIM To: Anders Svensson , "pgsql-sql@postgresql.org" In-Reply-To: References: Subject: Re: Join push down on FDW partitions MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 02 Dec 2020 17:44:43 +0300 Message-Id: <303241606920064@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj48ZGl2PkhpIEFuZGVycyw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JIGhhdmVuJ3QgdGVz dGVkIHdpdGggaGFzaCBwYXJ0aXRpb25pbmcuIEJ1dCwgSSB0aGluayBlbmFibGluZyA8ZW0+ZW5h YmxlX3BhcnRpdGlvbndpc2Vfam9pbjwvZW0+IGNhbiBoZWxwIHlvdS4gQ291bGQgeW91IHBsZWFz ZSB0cnkgdG8gZW5hYmxlIGFuZCBjaGVjayBpdHMgcXVlcnkgcGxhbj88L2Rpdj48L2Rpdj48ZGl2 PsKgPC9kaXY+PGRpdj5zZXQgZW5hYmxlX3BhcnRpdGlvbndpc2Vfam9pbiB0byBvbjs8L2Rpdj48 ZGl2PjxkaXY+ZXhwbGFpbiB2ZXJib3NlIHNlbGVjdCBwbS5waWQgZnJvbSBwbSBsZWZ0IGpvaW4g cHNnXzI0MCBvbiAocHNnXzI0MC5waWQgPSBwbS5waWQpIHdoZXJlIHBhcmFtMT0nZm9vQmFyJzsg wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Ob3RlOiBJdCB3aWxsIGVuYWJsZSB0aGlzIG9wdGlv biBvbmx5IGZvciB5b3VyIHNlc3Npb24uIFlvdSBuZWVkIHRvIHVwZGF0ZSB5b3VyIHBvc3RncmVz cWwuY29uZiBhbmQgcmVsb2FkIGl0IHRvIGVuYWJsZSBmb3IgZXZlcnlib2R5LjwvZGl2PjxkaXY+ PGRpdj4qIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTMvcnVudGltZS1jb25maWct cXVlcnkuaHRtbDwvZGl2PjwvZGl2PjwvZGl2PjxkaXY+QmVzdCByZWdhcmRzLjwvZGl2PjxkaXY+ U2FtZWQgWUlMRElSSU08L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4wMi4xMi4yMDIwLCAxNzozNSwg IkFuZGVycyBTdmVuc3NvbiIgJmx0O2FuZGVycy5zdmVuc3NvbkBhZ2FtYS50diZndDs6PC9kaXY+ PGJsb2NrcXVvdGU+PGRpdj48ZGl2IHN0eWxlPSJjb2xvcjpyZ2IoIDAgLCAwICwgMCApO2ZvbnQt ZmFtaWx5OidjYWxpYnJpJyAsICdhcmlhbCcgLCAnaGVsdmV0aWNhJyAsIHNhbnMtc2VyaWY7Zm9u dC1zaXplOjEycHQiPkhpLjxiciAvPjxiciAvPkkgaGF2ZSBub3QgZm91bmQgYW55IGluLWRlcHRo IGV4YW1wbGVzIHJlZ2FyZGluZyBqb2luIHB1c2ggZG93biBhbmQgdGhlIHN1cHBvcnQgZm9yIEZE V3MgYnV0IGZyb20gd2hhdCBJIGhhdmUgcmVhZCBteTxiciAvPnRlc3Qgb2YgaXQgc2hvdWxkIHdv cmsgYnV0IGlzIGRvZXMgbm90LiBJIGhhdmUgdGVzdGVkIG9uIGJvdGggUEcgMTEgYW5kIFBHIDEz PGJyIC8+PGJyIC8+SSBoYXZlIHR3byByZW1vdGUgc2hhcmRzIG9uZSBvbiBzZXJ2ZXIgY2xvdWQx IGFuZCB0aGUgb3RoZXIgY2xvdWQyPGJyIC8+PGJyIC8+SSBkbyB0aGUgZm9sbG93aW5nPGJyIC8+ wqA8ZGl2PkNSRUFURSBTQ0hFTUEgY2xvdWQxOzwvZGl2PjxkaXY+Q1JFQVRFIFNFUlZFUiBjbG91 ZDEgRk9SRUlHTiBEQVRBIFdSQVBQRVIgcG9zdGdyZXNfZmR3IE9QVElPTlMgKGhvc3QgJ3gueS56 LncnLCBwb3J0ICc1NDM2JywgZGJuYW1lICdteWRiJyk7PC9kaXY+PGRpdj5DUkVBVEUgVVNFUiBN QVBQSU5HIEZPUiB1c2VyMSBTRVJWRVIgY2xvdWQxIE9QVElPTlMgKHVzZXIgJ3VzZXIxJywgcGFz c3dvcmQgJ2lnUDN0YXNkc2FkJyk7PC9kaXY+PGRpdj5JTVBPUlQgRk9SRUlHTiBTQ0hFTUEgcHVi bGljIExJTUlUIFRPIChwc2dfMjQwICxwbSkgRlJPTSBTRVJWRVIgY2xvdWQxIElOVE8gY2xvdWQx OzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkNSRUFURSBTQ0hFTUEgY2xvdWQyOzwvZGl2PjxkaXY+ Q1JFQVRFIFNFUlZFUiBjbG91ZDIgRk9SRUlHTiBEQVRBIFdSQVBQRVIgcG9zdGdyZXNfZmR3IE9Q VElPTlMgKGhvc3QgJ3gueS56LncnLCBwb3J0ICc1NDM2JywgZGJuYW1lICdteWRiJyk7PC9kaXY+ PGRpdj5DUkVBVEUgVVNFUiBNQVBQSU5HIEZPUiBhZ2FtYSBTRVJWRVIgY2xvdWQyIE9QVElPTlMg KHVzZXIgJ2FnYW1hJywgcGFzc3dvcmQgJ2lnUDN0PHNwYW4gc3R5bGU9ImJhY2tncm91bmQtY29s b3I6I2ZmZmZmZiI+YXNkc2FkPC9zcGFuPicpOzwvZGl2PjxkaXY+SU1QT1JUIEZPUkVJR04gU0NI RU1BIHB1YmxpYyBMSU1JVCBUTyAocHNnXzI0MCwgcG0pIEZST00gU0VSVkVSIGNsb3VkMiBJTlRP IGNsb3VkMjs8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5EUk9QIFRBQkxFIElGIEVYSVNUUyBwbTs8 L2Rpdj48ZGl2PkNSRUFURSBUQUJMRSBwbSAoTElLRSBjbG91ZDEucG0gSU5DTFVESU5HIEFMTCkg UEFSVElUSU9OIEJZIEhBU0gocGlkKTs8L2Rpdj48ZGl2PkFMVEVSIFRBQkxFIHBtIEFUVEFDSCBQ QVJUSVRJT04gY2xvdWQxLnBtIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAyLCByZW1haW5kZXIg MCk7PC9kaXY+PGRpdj5BTFRFUiBUQUJMRSBwbSBBVFRBQ0ggUEFSVElUSU9OIGNsb3VkMi5wbSBG T1IgVkFMVUVTIFdJVEggKG1vZHVsdXMgMiwgcmVtYWluZGVyIDEpOzwvZGl2PjxkaXY+wqA8L2Rp dj48ZGl2PkRST1AgVEFCTEUgSUYgRVhJU1RTIHBzZ18yNDA7PC9kaXY+PGRpdj5DUkVBVEUgVEFC TEUgcHNnXzI0MCAoTElLRSBjbG91ZDEucHNnXzI0MCBJTkNMVURJTkcgQUxMKSBQQVJUSVRJT04g QlkgSEFTSChwaWQpOzwvZGl2PjxkaXY+QUxURVIgVEFCTEUgcHNnXzI0MCBBVFRBQ0ggUEFSVElU SU9OIGNsb3VkMS5wc2dfMjQwIEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAyLCByZW1haW5kZXIg MCk7PC9kaXY+PGRpdj5BTFRFUiBUQUJMRSBwc2dfMjQwIEFUVEFDSCBQQVJUSVRJT04gY2xvdWQy LnBzZ18yNDAgRk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDIsIHJlbWFpbmRlciAxKTs8L2Rpdj48 YnIgLz5UaGVuIHRoZSBxdWVyecKgPGJyIC8+PGJyIC8+ZXhwbGFpbiB2ZXJib3NlIHNlbGVjdCBw bS5waWQgZnJvbSBwbSBsZWZ0IGpvaW4gcHNnXzI0MCBvbiAocHNnXzI0MC5waWQgPSBwbS5waWQp IHdoZXJlIHBhcmFtMT0nZm9vQmFyJzsgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqA8YnIgLz48YnIgLz5HaXZlczwvZGl2PjxkaXYgc3R5bGU9ImNv bG9yOnJnYiggMCAsIDAgLCAwICk7Zm9udC1mYW1pbHk6J2NhbGlicmknICwgJ2FyaWFsJyAsICdo ZWx2ZXRpY2EnICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTJwdCI+wqA8L2Rpdj48ZGl2IHN0eWxl PSJjb2xvcjpyZ2IoIDAgLCAwICwgMCApO2ZvbnQtZmFtaWx5OidjYWxpYnJpJyAsICdhcmlhbCcg LCAnaGVsdmV0aWNhJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjEycHQiPsKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIFFVRVJZIFBMQU4gwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8ZGl2Pi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08L2Rpdj48ZGl2PsKgSGFzaCBSaWdo dCBKb2luIMKgKGNvc3Q9Mzg0Ljk3Li43MTAuMDMgcm93cz02NjYgd2lkdGg9OCk8L2Rpdj48ZGl2 PsKgIMKgT3V0cHV0OiBwbS5waWQ8L2Rpdj48ZGl2PsKgIMKgSGFzaCBDb25kOiAocHNnLnBpZCA9 IHBtLnBpZCk8L2Rpdj48ZGl2PsKgIMKgLSZndDsgwqBBcHBlbmQgwqAoY29zdD0xMDAuMDAuLjM5 OS4yMCByb3dzPTUxMjAgd2lkdGg9OCk8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgLSZndDsgwqBG b3JlaWduIFNjYW4gb24gY2xvdWQxLnBzZ18yNDAgcHNnXzEgwqAoY29zdD0xMDAuMDAuLjE4Ni44 MCByb3dzPTI1NjAgd2lkdGg9OCk8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgT3V0 cHV0OiBwc2dfMS5waWQ8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgUmVtb3RlIFNR TDogU0VMRUNUIHBpZCBGUk9NIHB1YmxpYy5wc2dfMjQwPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDC oC0mZ3Q7IMKgRm9yZWlnbiBTY2FuIG9uIGNsb3VkMi5wc2dfMjQwIHBzZ18yIMKgKGNvc3Q9MTAw LjAwLi4xODYuODAgcm93cz0yNTYwIHdpZHRoPTgpPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDC oCDCoCDCoE91dHB1dDogcHNnXzIucHJvYmVfaWQ8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgUmVtb3RlIFNRTDogU0VMRUNUIHBpZCBGUk9NIHB1YmxpYy5wc2dfMjQwPC9kaXY+PGRp dj7CoCDCoC0mZ3Q7IMKgSGFzaCDCoChjb3N0PTI4NC42NS4uMjg0LjY1IHJvd3M9MjYgd2lkdGg9 OCk8L2Rpdj48ZGl2PsKgIMKgIMKgIMKgIMKgT3V0cHV0OiBwbS5waWQ8L2Rpdj48ZGl2PsKgIMKg IMKgIMKgIMKgLSZndDsgwqBBcHBlbmQgwqAoY29zdD0xMDAuMDAuLjI4NC42NSByb3dzPTI2IHdp ZHRoPTgpPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoC0mZ3Q7IMKgRm9yZWlnbiBT Y2FuIG9uIGNsb3VkMS5wbSBwbV8xIMKgKGNvc3Q9MTAwLjAwLi4xNDIuMjYgcm93cz0xMyB3aWR0 aD04KTwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBPdXRwdXQ6IHBt XzEucGlkPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoFJlbW90ZSBT UUw6IFNFTEVDVCBwaWQgRlJPTSBwdWJsaWMucHJvYmVfbWV0YWRhdGEgV0hFUkUgKChwYXJhbTEg PSAnZm9vQmFyJzo6dGV4dCkpPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoC0mZ3Q7 IMKgRm9yZWlnbiBTY2FuIG9uIGNsb3VkMi5wbSBwbV8yIMKgKGNvc3Q9MTAwLjAwLi4xNDIuMjYg cm93cz0xMyB3aWR0aD04KTwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqBPdXRwdXQ6IHBtXzIucGlkPC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoFJlbW90ZSBTUUw6IFNFTEVDVCBwaWQgRlJPTSBwdWJsaWMucG0gV0hFUkUgKChwYXJhbTEg PSAnZm9vQmFyJzo6dGV4dCkpPC9kaXY+PGRpdj4oMTkgcm93cyk8L2Rpdj48YnIgLz48YnIgLz5J IHdvdWxkIGV4cGVjdCB0aGF0IHRoZSBqb2luIHdoZXJlIHB1c2g6ZWQgZG93biB0byB0aGUgc2hh cmRzLjxiciAvPjxiciAvPkRvZXMgUG9zdGdyZXMgc3VwcG9ydCB0aGlzIGtpbmQgb2YgdXNlY2Fz ZT8gSWYgc28gd2hhdCBkbyBJIGRvIHdyb25nIGhlcmU/PGJyIC8+PGJyIC8+YmVzdCByZWdhcmRz LDxiciAvPsKgIEFuZGVyczwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT4=