Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0P8V-00007E-AU for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Sep 2018 10:46:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0P8S-00010O-NS for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Sep 2018 10:46:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0P8S-00010H-HO for pgsql-bugs@lists.postgresql.org; Thu, 13 Sep 2018 10:46:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0P8P-0006oc-8Z for pgsql-bugs@lists.postgresql.org; Thu, 13 Sep 2018 10:46:08 +0000 Content-Type: multipart/mixed; boundary="===============4152182322250853907==" MIME-Version: 1.0 Subject: BUG #15383: Join Filter cost estimation problem in 10.5 To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: marko@joh.to Reply-To: marko@joh.to, pgsql-bugs@lists.postgresql.org Date: Thu, 13 Sep 2018 10:45:21 +0000 Message-ID: <153683552113.22350.18441286362867559841@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4152182322250853907== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTM4MwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmtvIFRpaWtrYWphCkVt YWlsIGFkZHJlc3M6ICAgICAgbWFya29Aam9oLnRvClBvc3RncmVTUUwgdmVyc2lvbjogMTAuNQpP cGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpJIHdhcyBsb29r aW5nIGF0IGEgcHJvYmxlbWF0aWMgcGxhbiBzdWJtaXR0ZWQgYnkgInNqYW1hYW4iIG9uIElSQyBh bmQgSQpub3RpY2VkIHRoYXQgdGhlIGpvaW4gZmlsdGVyIGVzdGltYXRpb24gc2VlbXMgY29tcGxl dGVseSB3cm9uZyBoZXJlOg0KDQpjcmVhdGUgZnVuY3Rpb24gZXhwZW5zaXZlX2Z1bmMoaW50KSBy ZXR1cm5zIGludCBhcyAkJCBiZWdpbiByZXR1cm4gMTsgZW5kICQkCmxhbmd1YWdlIHBscGdzcWwg c3RhYmxlIGNvc3QgMTAwMDA7DQpjcmVhdGUgdGFibGUgdW5pcXVlX2lubmVyKGEgaW50IHByaW1h cnkga2V5KTsNCmluc2VydCBpbnRvIHVuaXF1ZV9pbm5lciBzZWxlY3QgZ2VuZXJhdGVfc2VyaWVz KDEsIDEwMDAwKTsNCg0KZXhwbGFpbiBzZWxlY3QgKiBmcm9tIHVuaXF1ZV9pbm5lciBnczEoaSkg am9pbiBnZW5lcmF0ZV9zZXJpZXMoMSwgMTApIGdzMihpKQp1c2luZyAoaSkgd2hlcmUgZXhwZW5z aXZlX2Z1bmMoZ3MxLmkgKyBnczIuaSkgPiAwOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgUVVFUlkgUExBTg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEhhc2ggSm9p biAgKGNvc3Q9MzAzLjE5Li4zMTUuODEgcm93cz0zMzMgd2lkdGg9NCkNCiAgIEhhc2ggQ29uZDog KGdzMi5pID0gZ3MxLmkpDQogICBKb2luIEZpbHRlcjogKGV4cGVuc2l2ZV9mdW5jKChnczEuaSAr IGdzMi5pKSkgPiAwKQ0KICAgLT4gIEZ1bmN0aW9uIFNjYW4gb24gZ2VuZXJhdGVfc2VyaWVzIGdz MiAgKGNvc3Q9MC4wMC4uMTAuMDAgcm93cz0xMDAwCndpZHRoPTQpDQogICAtPiAgSGFzaCAgKGNv c3Q9MTU5Ljc1Li4xNTkuNzUgcm93cz0xMTQ3NSB3aWR0aD00KQ0KICAgICAgICAgLT4gIFNlcSBT Y2FuIG9uIHVuaXF1ZV9pbm5lciBnczEgIChjb3N0PTAuMDAuLjE1OS43NSByb3dzPTExNDc1Cndp ZHRoPTQpDQooNiByb3dzKQ0KDQooTm90aWNlIGhvdyBldmVuIHRob3VnaCB0aGUgZnVuY3Rpb24g aXMgZXhwZWN0ZWQgdG8gYmUgY2FsbGVkIGF0IGxlYXN0IDMzMwp0aW1lcywgdGhlIGNvc3QgZG9l c24ndCBhY2NvdW50IGZvciBldmVuIGEgc2luZ2xlIGNhbGwuKQ0KDQpEcm9wcGluZyB0aGUgcHJp bWFyeSBrZXkgY29uc3RyYWludCBtYWtlcyB0aGUgY29zdHMgbW9yZSByZWFzb25hYmxlICh0aG91 Z2gKSSdtIHN0aWxsIG5vdCBzdXJlIGhvdyB0aGUgcGxhbm5lciBhcnJpdmVzIGF0IHRoZXNlIGNv c3RzKToNCg0KYWx0ZXIgdGFibGUgdW5pcXVlX2lubmVyIGRyb3AgY29uc3RyYWludCB1bmlxdWVf aW5uZXJfcGtleTsNCmV4cGxhaW4gc2VsZWN0ICogZnJvbSB1bmlxdWVfaW5uZXIgZ3MxKGkpIGpv aW4gZ2VuZXJhdGVfc2VyaWVzKDEsIDEwKSBnczIoaSkKdXNpbmcgKGkpIHdoZXJlIGV4cGVuc2l2 ZV9mdW5jKGdzMS5pICsgZ3MyLmkpID4gMDsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIFFVRVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBI YXNoIEpvaW4gIChjb3N0PTIyLjUwLi4xNDM2ODgwLjk0IHJvd3M9MTkxMjUgd2lkdGg9NCkNCiAg IEhhc2ggQ29uZDogKGdzMS5pID0gZ3MyLmkpDQogICBKb2luIEZpbHRlcjogKGV4cGVuc2l2ZV9m dW5jKChnczEuaSArIGdzMi5pKSkgPiAwKQ0KICAgLT4gIFNlcSBTY2FuIG9uIHVuaXF1ZV9pbm5l ciBnczEgIChjb3N0PTAuMDAuLjE1OS43NSByb3dzPTExNDc1CndpZHRoPTQpDQogICAtPiAgSGFz aCAgKGNvc3Q9MTAuMDAuLjEwLjAwIHJvd3M9MTAwMCB3aWR0aD00KQ0KICAgICAgICAgLT4gIEZ1 bmN0aW9uIFNjYW4gb24gZ2VuZXJhdGVfc2VyaWVzIGdzMiAgKGNvc3Q9MC4wMC4uMTAuMDAKcm93 cz0xMDAwIHdpZHRoPTQpDQooNiByb3dzKQoK --===============4152182322250853907==--