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 1mWAjZ-0001tK-CJ for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Oct 2021 05:05:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mWAjX-00049D-2o for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Oct 2021 05:05:19 +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 1mW5VH-0005we-74 for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 23:30:15 +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 1mW5V8-0002EQ-7c for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 23:30:13 +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=k7RMox1A3PV0fjM29YcZ5VPAU9HWqjEl8Ilm2X/nRN0=; b=B0x8E4L/oUsqbC7qUItykUBATI 8NO6IMVHOeuQKYMZ+RomNoRsElLjsED5KvyscxaENRn6z2w5SshQ+cJIcBNM/8/eGszaYI+6MfLl0 GVqdQU0dDIDffEvZlIATxeXax91A5XGki0ot+xAHr+prfEYBCSdxM3HvO3KxDzBcgG1A/GWNozU0g xZHc7CPVBF4QhwX0rAATOM5QDqDmh6uBMwmeP6gBuBmdjzsVeOSI04imOob00MTx9y3UppZnySB54 Elgdhcw1y8D88GT34koW0PpSzbLgN25cFlZAOJbm1GjClKOJahBvTvlFqhhHO3MR00FXxyj1dUv0n tLkGloOw==; 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 1mW5V6-0000Sw-Kv for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 23:30: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 1mW5V5-0008W3-Bp for pgsql-bugs@lists.postgresql.org; Thu, 30 Sep 2021 23:30:03 +0000 Content-Type: multipart/mixed; boundary="===============2190328235207391853==" MIME-Version: 1.0 Subject: BUG #17207: Bad cost estimate of Merge Join despite correct row estimate To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sema@sema.in Reply-To: sema@sema.in, pgsql-bugs@lists.postgresql.org Date: Thu, 30 Sep 2021 23:29:48 +0000 Message-ID: <17207-5265aefa79e333b4@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 --===============2190328235207391853== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIwNwpMb2dnZWQgYnk6ICAgICAgICAgIFNpbW9uIFBlcmVwZWxpdHNh CkVtYWlsIGFkZHJlc3M6ICAgICAgc2VtYUBzZW1hLmluClBvc3RncmVTUUwgdmVyc2lvbjogMTMu NApPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIDEwLjE1LjcKRGVzY3JpcHRpb246ICAgICAgICAK ClNldHVwDQoNCiAgICBjcmVhdGUgdGFibGUgdGVzdF91c2VycyAoaWQgc2VyaWFsIHByaW1hcnkg a2V5KTsNCiAgICBjcmVhdGUgdGFibGUgdGVzdF91c2VyX3Nlc3Npb25zIChpZCBzZXJpYWwgcHJp bWFyeSBrZXksIHVzZXJfaWQgaW50IG5vdApudWxsIHJlZmVyZW5jZXMgdGVzdF91c2VycyhpZCkp Ow0KICAgIGluc2VydCBpbnRvIHRlc3RfdXNlcnMgKGlkKSBzZWxlY3QgZ2VuZXJhdGVfc2VyaWVz KDEsIDUwMDAwMCkgYXMgaWQ7DQogICAgaW5zZXJ0IGludG8gdGVzdF91c2VyX3Nlc3Npb25zICh1 c2VyX2lkKSB2YWx1ZXMNCiAgICAgICgxKSwNCiAgICAgICgxKSwNCiAgICAgICg1MDAwMDApOw0K ICAgIHZhY3V1bSB2ZXJib3NlIGFuYWx5emUgdGVzdF91c2VycywgdGVzdF91c2VyX3Nlc3Npb25z Ow0KDQpRdWVyeQ0KDQogICAgZXhwbGFpbiBhbmFseXplDQogICAgc2VsZWN0IHRlc3RfdXNlcl9z ZXNzaW9ucy5pZCBmcm9tIHRlc3RfdXNlcl9zZXNzaW9ucyBqb2luIHRlc3RfdXNlcnMgb24KdXNl cl9pZCA9IHRlc3RfdXNlcnMuaWQ7DQoNCiAgICBNZXJnZSBKb2luICAoY29zdD0xLjQ5Li4xLjU1 IHJvd3M9MyB3aWR0aD00KSAoYWN0dWFsIHRpbWU9MC4wMTUuLjcxLjAzNApyb3dzPTMgbG9vcHM9 MSkNCiAgICAgIE1lcmdlIENvbmQ6ICh0ZXN0X3VzZXJzLmlkID0gdGVzdF91c2VyX3Nlc3Npb25z LnVzZXJfaWQpDQogICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIHRlc3RfdXNlcnNfcGtl eSBvbiB0ZXN0X3VzZXJzIAooY29zdD0wLjQyLi4xMjk5Ni40MiByb3dzPTUwMDAwMCB3aWR0aD00 KSAoYWN0dWFsIHRpbWU9MC4wMDUuLjQwLjA0MApyb3dzPTUwMDAwMCBsb29wcz0xKQ0KICAgICAg ICAgICAgSGVhcCBGZXRjaGVzOiAwDQogICAgICAtPiAgU29ydCAgKGNvc3Q9MS4wNS4uMS4wNiBy b3dzPTMgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDA5Li4wLjAxMApyb3dzPTMgbG9vcHM9MSkN CiAgICAgICAgICAgIFNvcnQgS2V5OiB0ZXN0X3VzZXJfc2Vzc2lvbnMudXNlcl9pZA0KICAgICAg ICAgICAgU29ydCBNZXRob2Q6IHF1aWNrc29ydCAgTWVtb3J5OiAyNWtCDQogICAgICAgICAgICAt PiAgU2VxIFNjYW4gb24gdGVzdF91c2VyX3Nlc3Npb25zICAoY29zdD0wLjAwLi4xLjAzIHJvd3M9 Mwp3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMDQuLjAuMDA1IHJvd3M9MyBsb29wcz0xKQ0KICAg IFBsYW5uaW5nIFRpbWU6IDAuMTA2IG1zDQogICAgRXhlY3V0aW9uIFRpbWU6IDcxLjA2MSBtcw0K DQpBZnRlciBzZXQgZW5hYmxlX21lcmdlam9pbiA9IGZhbHNlDQoNCiAgICBOZXN0ZWQgTG9vcCAg KGNvc3Q9MC40Mi4uMTQuMzUgcm93cz0zIHdpZHRoPTQpIChhY3R1YWwgdGltZT0wLjAxOS4uMC4w MjUKcm93cz0zIGxvb3BzPTEpDQogICAgICAtPiAgU2VxIFNjYW4gb24gdGVzdF91c2VyX3Nlc3Np b25zICAoY29zdD0wLjAwLi4xLjAzIHJvd3M9MyB3aWR0aD04KQooYWN0dWFsIHRpbWU9MC4wMDYu LjAuMDA2IHJvd3M9MyBsb29wcz0xKQ0KICAgICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyB0 ZXN0X3VzZXJzX3BrZXkgb24gdGVzdF91c2VycyAKKGNvc3Q9MC40Mi4uNC40NCByb3dzPTEgd2lk dGg9NCkgKGFjdHVhbCB0aW1lPTAuMDA1Li4wLjAwNSByb3dzPTEgbG9vcHM9MykNCiAgICAgICAg ICAgIEluZGV4IENvbmQ6IChpZCA9IHRlc3RfdXNlcl9zZXNzaW9ucy51c2VyX2lkKQ0KICAgICAg ICAgICAgSGVhcCBGZXRjaGVzOiAwDQogICAgUGxhbm5pbmcgVGltZTogMC4wNzggbXMNCiAgICBF eGVjdXRpb24gVGltZTogMC4wNDAgbXMNCg0KQXMgeW91IGNhbiBzZWUsIE1lcmdlIEpvaW4gYWRk cyBqdXN0IDAuNSBjb3N0IG9uIHRvcCBvZiBTZXEgU2NhbiBpZ25vcmluZwp0aGUgaGlnaCBjb3N0 IG9mIGZ1bGwgaW5kZXggc2NhbiAoMC40Mi4uMTI5OTYuNDIpLiBJZiBleHBsaWNpdGx5IGRpc2Fi bGVkLApOZXN0ZWQgTG9vcCBpcyBvYnZpb3VzbHkgYSBtdWNoIGJldHRlciBqb2luIHBsYW4gZm9y IHN1Y2ggYSBzbWFsbCB0YWJsZSAoMwpyb3dzKS4NCg0KV2hpbGUgaXQgaXMgcG9zc2libGUgZm9y IE1lcmdlIEpvaW4gdG8gYWxzbyBmaW5pc2ggcXVpY2tseSAtIGlmIHVzZXJfaWQgYXJlCmFsbCBs b3cgbnVtYmVycyAtIEknbSBub3Qgc3VyZSBpZiB0aGF0J3MgYSByZWFsaXN0aWMgZXhwZWN0YXRp b24gZm9yIHRoZQpkZWZhdWx0IHBsYW4uDQoNCkkgYWxzbyB0cmllZCByZXdyaXRpbmcgaXQgYXMg YSBzZW1pLWpvaW4gd2l0aCBleGlzdHMvaW4sIGJ1dCB0aGUgcXVlcnkgcGxhbnMKd2VyZSBleGFj dGx5IHRoZSBzYW1lLiBOb3Qgc3VyZSB3aHksIGJlY2F1c2UgaW4gc29tZSBvZiBteSBvdGhlciBx dWVyaWVzCnRoaXMgbWFrZXMgdGhlIHBsYW5uZXIgdXNlIG1vcmUgb3B0aW1pemVkICJTZW1pLUpv aW4iIGluc3RydWN0aW9ucyAoZS5nLgpOZXN0ZWQgTG9vcCBTZW1pLUpvaW4pLg0KDQogICAgZXhw bGFpbiBhbmFseXplDQogICAgc2VsZWN0IHRlc3RfdXNlcl9zZXNzaW9ucy5pZCBmcm9tIHRlc3Rf dXNlcl9zZXNzaW9ucyB3aGVyZSBleGlzdHMKKHNlbGVjdCAxIGZyb20gdGVzdF91c2VycyB3aGVy ZSB1c2VyX2lkID0gdGVzdF91c2Vycy5pZCk7Cgo= --===============2190328235207391853==--