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 1qOcMe-008Qfz-76 for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Jul 2023 11:07:32 +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 1qOcMc-003pKy-7L for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Jul 2023 11:07:30 +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 1qOWEy-002Eue-0Q for pgsql-bugs@lists.postgresql.org; Wed, 26 Jul 2023 04:35:12 +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 1qOWEs-000Pal-P3 for pgsql-bugs@lists.postgresql.org; Wed, 26 Jul 2023 04:35:11 +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=IEH//ywag5wGJ1UoDZp90PAGmZA8EXXdzmqwXsUn5FE=; b=KSct2uCHI+IgS24WaJFI2XAxYE zVrHIaHeIyQTISYtiZf4F0+U0rD3+l3mtx+gigrleFOc0hEATFPKmcPudy2wuxaXxPATc6Pfv1FIk oCXbJ7WVaSf7GQ81n/qKL/YzyOgaZvAtePbhyo6fGs74KiATW3hBmrK8TDPqrOHLuHCZE7LF2tU30 IVQff0BQNZx4WL9dCLSf8Sujqyu177/w3pQcyFIXiDPAWiWRqrKF5irtw0xRH6uP4y1yKa6tZ1yZG 3jvBtRFtz/To1s19FKGE2Hwq2cVRTtlLqtGBgPyCkR05oeXOXao/X+sG7/Mv7wYCpP+kZmhfoTHNk S/F7MnDw==; 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 1qOWEr-0001ZD-3K for pgsql-bugs@lists.postgresql.org; Wed, 26 Jul 2023 04:35: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 1qOWEo-0015oA-Dq for pgsql-bugs@lists.postgresql.org; Wed, 26 Jul 2023 04:35:02 +0000 Content-Type: multipart/mixed; boundary="===============4620274523174890121==" MIME-Version: 1.0 Subject: BUG #18036: Query planner chooses sub-optimal query path given enough IN tuples. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: patrick@redbubble.com Reply-To: patrick@redbubble.com, pgsql-bugs@lists.postgresql.org Date: Wed, 26 Jul 2023 04:34:29 +0000 Message-ID: <18036-f168e30b92352489@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 --===============4620274523174890121== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODAzNgpMb2dnZWQgYnk6ICAgICAgICAgIFBhdHJpY2sgTGVhbW9uCkVt YWlsIGFkZHJlc3M6ICAgICAgcGF0cmlja0ByZWRidWJibGUuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIFVuc3VyZSAtIEFXUyBBdXJvcmEgUG9zdGdyZVNR TApEZXNjcmlwdGlvbjogICAgICAgIAoKSGksDQogIEknbSBoaXR0aW5nIHNvbWUgb2RkIHF1ZXJ5 IHBsYW5zLiAgVGhlIHN0cnVjdHVyZSBvZiB0aGUgcXVlcnkgaXMgbGlrZQp0aGlzOg0KDQpTRUxF Q1QgZmllbGQxLCBmaWVsZDIsIGZpZWxkMw0KRlJPTSBteV90YWJsZQ0KV0hFUkUgKGZpZWxkMSwg ZmllbGQyKSBJTiAoKCJhIiwgImIiKSwgKCJjIiwgImIiKSkNCg0KVGhlcmUgaXMgYSBjb21wb3Np dGUgaW5kZXggb24gZmllbGQxICsgZmllbGQyIGluIHRoYXQgb3JkZXIuDQoNCldoZW4gdGhlIHF1 ZXJ5IGlzIHdvcmtpbmcgd2VsbCwgSSBlbmQgdXAgd2l0aCBhIHF1ZXJ5IHBsYW4gdGhhdCBsb29r cwpsaWtlOg0KDQpCaXRtYXBPcg0KIC0+IEJpdG1hcCBJbmRleCBTY2FuDQogICAgLT4gSW5kZXgg Q29uZCAoZmllbGQxPSJhIiBBTkQgZmllbGQyPSJiIikNCiAtPiBCaXRtYXAgSW5kZXggU2Nhbg0K ICAgIC0+IEluZGV4IENvbmQgKGZpZWxkMT0iYyIgQU5EIGZpZWxkMj0iZCIpDQoNClRoaXMgaXMg Z3JlYXQgYW5kIHN1cGVyIGZhc3QuDQoNCldoZW4gSSBnaXZlICJ0b28gbWFueSIgdHVwbGVzIGlu IHRoZSBJTiBjbGF1c2UsIEkgZW5kIHVwIHdpdGggYSBxdWVyeSBwbGFuCmxpa2UgdGhpczoNCg0K Qml0bWFwQW5kDQogIEJpdG1hcE9yDQogICAtPiBCaXRtYXAgSW5kZXggU2Nhbg0KICAgICAgLT4g SW5kZXggQ29uZCAoZmllbGQxPSJhIiBBTkQgZmllbGQyPSJiIikNCiAgIC0+IEJpdG1hcCBJbmRl eCBTY2FuDQogICAgICAtPiBJbmRleCBDb25kIChmaWVsZDE9ImMiIEFORCBmaWVsZDI9ImIiKQ0K ICBCaXRtYXAgSW5kZXggU2Nhbg0KICAgIC0+ICBJbmRleCBDb25kIChmaWVsZDI9ImIiKQ0KICAg IA0KVGhpcyBpcyBub3QgZ3JlYXQgYW5kIHZlcnkgc2xvdy4NCg0KVGhlIGV4YW1wbGUgYWJvdmUg aXMgc2ltcGxpZmllZCwgaW4gcmVhbGl0eSB0aGlzIGlzIGEgNCBiaWxsaW9uIHJvdyB0YWJsZS4g CmZpZWxkIDIgaGFzIG9ubHkgYXJvdW5kIDEwMCBkaWZmZXJlbnQgdmFsdWVzLCB3aGVyZSBmaWVs ZCAxIGhhcyBtaWxsaW9ucy4gClNvIHNjYW5uaW5nIHRoZSBpbmRleCBvbiB0aGUgIndyb25nIHNp ZGUiIG9mIHRoZSBjb21wb3NpdGUgaW5kZXggaXMgdmVyeQpjb3N0bHkgYW5kIGVuZHMgdXAgdGlt aW5nIG91dC4NCg0KT3ZlciB0aW1lIHRoZSB2YWx1ZSBvZiAidG9vIG1hbnkiIHR1cGxlcyBpcyB0 cmVuZGluZyBkb3duLiAgMTAwIHVzZWQgdG8gYmUKZmluZSwgbm93IHRoYXQncyBoYXZpbmcgaXNz dWVzIHRvby4NCg0KV2h5IHdvdWxkIHRoZSBxdWVyeSBwbGFubmVyIGV2ZXIgY2hvb3NlIHRvIHNj YW4gYSBjb21wb3NpdGUgaW5kZXggb24gdGhlCnNlY29uZGFyeSBjb2x1bW4/Cgo= --===============4620274523174890121==--