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 1oH8gw-0004WX-Pz for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Jul 2022 18:57:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oH8gv-00064J-La for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Jul 2022 18:57:01 +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 1oH6ZT-0003Xd-B4 for pgsql-bugs@lists.postgresql.org; Thu, 28 Jul 2022 16:41:11 +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 1oH6ZP-0007sO-4L for pgsql-bugs@lists.postgresql.org; Thu, 28 Jul 2022 16:41:10 +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=q9zvJlHAMucpQnOtcP9l/s/oqvxjgrKeKhqhZR+cQow=; b=jiD6wqYG197vFmSYjw3TR4rt46 VbI8fY4hnW/glN6BajoL3gzhz+lwhJkn1DqBPAo5bH/zkLycuf8bzZfEelW6iWyv/j9pWyg4eqKsP W1scf7kIahUEA1lSzDLB96iByjd7z3gcqmalJ5lajKmxemLp6Bzf6Ksveh4hH5gqLzPS/V/IeHmKg ZIjluZjezQxe4zY7rdaTetPHGGvvxc0J4UqYciZEvgYtWLY4F8ef9xDOktpRW0CJZzOIZELnpRT7z jYbM5DnqMof+KkZrR9ORPdAz+BRa024F547PYzeCWPti8iggIXXZqBHy42S5J+O20jI6rwPC4zF5u UuZ5s9hA==; 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 1oH6ZN-0001ii-Eu for pgsql-bugs@lists.postgresql.org; Thu, 28 Jul 2022 16:41: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 1oH6ZJ-008msk-UQ for pgsql-bugs@lists.postgresql.org; Thu, 28 Jul 2022 16:41:02 +0000 Content-Type: multipart/mixed; boundary="===============7318042545802842831==" MIME-Version: 1.0 Subject: BUG #17560: Planner can not find plan with lowest cost 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: Thu, 28 Jul 2022 16:40:06 +0000 Message-ID: <17560-002af2afa26117b6@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 --===============7318042545802842831== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU2MApMb2dnZWQgYnk6ICAgICAgICAgIFN0YW5pc8WCYXcgU2tvbmll Y3pueQpFbWFpbCBhZGRyZXNzOiAgICAgIHN0YW5pc2xhdy5za29uaWVjem55QGdtYWlsLmNvbQpQ b3N0Z3JlU1FMIHZlcnNpb246IDE0LjQKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlw dGlvbjogICAgICAgIAoKV2UgaGF2ZSBmb3VuZCB0aGF0IG9uZSBvdXIgcXVlcmllcyB0YWtlcyBo b3VycyBpbnN0ZWFkIG9mIHNlY29uZHMuIFRoZSBxdWVyeQpkaWQgYSBqb2luIGJldHdlZW4gaHVn ZSB0YWJsZSAoYmlsbGlvbnMgb2Ygcm93cykgYW5kIDIgbXVjaCBzbWFsbGVyIHRlbXAKdGFibGVz ICh+MTBrIHJvd3MpLiBIdWdlIHRhYmxlIHdhcyBvZnRlbiBhbmFseXplZC4gVGVtcCB0YWJsZXMg dXNlZCBpbiBxdWVyeQp3ZXJlIGFuYWx5emVkIGp1c3QgYmVmb3JlIG1ha2luZyBhIHF1ZXJ5LiBU aGUgcGxhbmVyIGRlY2lkZWQgdG8gdXNlIGEKc2Vxc2NhbiBvbiBvbmUgb2YgdGhlIHRlbXAgdGFi bGVzIGluIHRoZSBsb29wIGNhdXNpbmcgaHVnZSBudW1iZXIgb2Ygcm93cwpyZW1vdmVkIGJ5IHRo ZSBqb2luIGZpbHRlciAoYFJvd3MgUmVtb3ZlZCBieSBKb2luIEZpbHRlcjogOTc2MzMxNjYyMTJg KQppbnN0ZWFkIG9mIHVzaW5nIGluZGV4IHNjYW4uDQoNCkkgd2FzIGFibGUgdG8gY3JlYXRlIGEg c2NyaXB0IHdoaWNoIHdvcmsgb24gc21hbGxlciBkYXRhIHNldCwgdXNlcwpzaW1wbGlmaWVkIHZl cnNpb24gb2YgdGhlIHF1ZXJ5IGFuZCBjYXVzZXMgc2ltaWxhciBwcm9ibGVtLiBXZSBoYXZlIGFs c28KZm91bmQgdGhhdCBkaXNhYmxpbmcgc2Vxc2NhbiBhbGxvd3MgUEcgdG8gZmluZCBiZXR0ZXIg cGxhbiwgZXZlbiBpbiB0ZXJtcyBvZgplc3RpbWF0ZWQgY29zdC4NCg0KVGhpcyBpcyBhIHNjcmlw dDoNCmBgYA0KLS0gcHJlcGFyZSBkYXRhIGFuZCB0YWJsZXMNCmNyZWF0ZSB0YWJsZSBzc19kIGFz IHNlbGVjdCBpIGFzIGlkLCBpICsgMTAwIGFzIHYxLCBpICsgMjAwIGFzIHYyLAonYXNkYXNkYXNk YXNkYXNkYXNkYXNkYXNkYXNkYXNkYXNkYXNkJyBhcyBkYXRhIGZyb20gZ2VuZXJhdGVfc2VyaWVz KDAsCjEwMDAwMDAwMCkgYXMgaTsNCmNyZWF0ZSB1bmlxdWUgaW5kZXggaWR4X3NzX2Qgb24gc3Nf ZCAoaWQpOw0KYW5hbHl6ZSBzc19kOw0KDQpjcmVhdGUgdGFibGUgc3NfdGVtcF90YWJsZTEgYXMg c2VsZWN0IGlkLCB2MSwgdjIgZnJvbSBzc19kIG9yZGVyIGJ5IGlkIGRlc2MKbGltaXQgMTAwMDAw Ow0KYW5hbHl6ZSBzc190ZW1wX3RhYmxlMTsNCmNyZWF0ZSBpbmRleCBpZHhfc3NfdGVtcF90YWJs ZTEgb24gc3NfdGVtcF90YWJsZTEgKGlkKTsNCg0KY3JlYXRlIHRhYmxlIHNzX3RlbXBfdGFibGUy IGFzIHNlbGVjdCBpZCBmcm9tIHNzX2Qgb3JkZXIgYnkgaWQgZGVzYyBsaW1pdAoxMDAwMDA7DQph bmFseXplIHNzX3RlbXBfdGFibGUyOw0KY3JlYXRlIGluZGV4IGlkeF9zc190ZW1wX3RhYmxlMiBv biBzc190ZW1wX3RhYmxlMiAoaWQpOw0KDQotLSBtYWtlIGEgcXVlcnkNCmV4cGxhaW4gYW5hbHl6 ZSBTRUxFQ1QgZC5pZCwgZC52MSwgZC52Mg0KICAgICAgICBGUk9NIHNzX2QgQVMgZA0KICAgICAg ICBKT0lOIHNzX3RlbXBfdGFibGUxIEFTIHQxIE9OIHQxLmlkID0gZC5pZCBBTkQgdDEudjEgPSBk LnYxIEFORCB0MS52Mgo9IGQudjINCiAgICAgICAgV0hFUkUNCiAgICAgICAgZC5pZCBJTg0KICAg ICAgICAgICAgKFNFTEVDVCB0Mi5pZA0KICAgICAgICAgICAgIEZST00gc3NfdGVtcF90YWJsZTIg QVMgdDIpOw0KDQotLSBtYWtlIGEgcXVlcnkgd2l0aCBkaXNhYmxlZCBzZXFzY2FuDQpzZXQgZW5h YmxlX3NlcXNjYW4gPSAnb2ZmJzsNCmV4cGxhaW4gYW5hbHl6ZSBTRUxFQ1QgZC5pZCwgZC52MSwg ZC52Mg0KICAgICAgICBGUk9NIHNzX2QgQVMgZA0KICAgICAgICBKT0lOIHNzX3RlbXBfdGFibGUx IEFTIHQxIE9OIHQxLmlkID0gZC5pZCBBTkQgdDEudjEgPSBkLnYxIEFORCB0MS52Mgo9IGQudjIN CiAgICAgICAgV0hFUkUNCiAgICAgICAgZC5pZCBJTg0KICAgICAgICAgICAgKFNFTEVDVCB0Mi5p ZA0KICAgICAgICAgICAgIEZST00gc3NfdGVtcF90YWJsZTIgQVMgdDIpOw0KYGBgDQoNClF1ZXJ5 IHBsYW4gaXM6DQpgYGANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQ0KIE5lc3RlZCBMb29wIFNlbWkgSm9pbiAgKGNvc3Q9MC4xMS4uNzM3NDQ2LjAwIHJvd3M9MSB3 aWR0aD0xMikgKGFjdHVhbAp0aW1lPTAuMDQ0Li41NDIyMTEuOTQwIHJvd3M9MTAwMDAwIGxvb3Bz PTEpDQogICBKb2luIEZpbHRlcjogKHQxLmlkID0gdDIuaWQpDQogICBSb3dzIFJlbW92ZWQgYnkg Sm9pbiBGaWx0ZXI6IDQ5OTk5NTAwMDANCiAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4xMS4u NzM0OTUzLjAwIHJvd3M9MSB3aWR0aD0xNikgKGFjdHVhbAp0aW1lPTAuMDMyLi40NTcuNDg0IHJv d3M9MTAwMDAwIGxvb3BzPTEpDQogICAgICAgICAtPiAgU2VxIFNjYW4gb24gc3NfdGVtcF90YWJs ZTEgdDEgIChjb3N0PTAuMDAuLjE1NDEuMDAgcm93cz0xMDAwMDAKd2lkdGg9MTIpIChhY3R1YWwg dGltZT0wLjAxMy4uMTMuMTU3IHJvd3M9MTAwMDAwIGxvb3BzPTEpDQogICAgICAgICAtPiAgSW5k ZXggU2NhbiB1c2luZyBpZHhfc3NfZCBvbiBzc19kIGQgIChjb3N0PTAuMTEuLjcuMzIgcm93cz0x CndpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMDMuLjAuMDAzIHJvd3M9MSBsb29wcz0xMDAwMDAp DQogICAgICAgICAgICAgICBJbmRleCBDb25kOiAoaWQgPSB0MS5pZCkNCiAgICAgICAgICAgICAg IEZpbHRlcjogKCh0MS52MSA9IHYxKSBBTkQgKHQxLnYyID0gdjIpKQ0KICAgLT4gIFNlcSBTY2Fu IG9uIHNzX3RlbXBfdGFibGUyIHQyICAoY29zdD0wLjAwLi4xNDQzLjAwIHJvd3M9MTAwMDAwCndp ZHRoPTQpIChhY3R1YWwgdGltZT0wLjAwMy4uMi43MzIgcm93cz01MDAwMCBsb29wcz0xMDAwMDAp DQogUGxhbm5pbmcgVGltZTogMS40MjAgbXMNCiBFeGVjdXRpb24gVGltZTogNTQyMjIzLjQzOCBt cw0KKDExIHJvd3MpDQpgYGANCg0KUXVlcnkgcGxhbiB3aXRoIGRpc2FibGVkIHNlcXNjYW4gaXM6 DQpgYGANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgClFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgDQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIE5lc3RlZCBM b29wIFNlbWkgSm9pbiAgKGNvc3Q9MC4yMy4uNzM2MTYwLjE0IHJvd3M9MSB3aWR0aD0xMikgKGFj dHVhbAp0aW1lPTAuMDI0Li4zNjIuNjQ3IHJvd3M9MTAwMDAwIGxvb3BzPTEpDQogICBKb2luIEZp bHRlcjogKHQxLmlkID0gdDIuaWQpDQogICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMTcuLjcz NjE2MC4wNiByb3dzPTEgd2lkdGg9MTYpIChhY3R1YWwKdGltZT0wLjAxOC4uMjI0LjQwMyByb3dz PTEwMDAwMCBsb29wcz0xKQ0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3NzX3Rl bXBfdGFibGUxIG9uIHNzX3RlbXBfdGFibGUxIHQxIAooY29zdD0wLjA2Li4yNzQ4LjA2IHJvd3M9 MTAwMDAwIHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMDguLjE4Ljk5MApyb3dzPTEwMDAwMCBs b29wcz0xKQ0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3NzX2Qgb24gc3NfZCBk ICAoY29zdD0wLjExLi43LjMyIHJvd3M9MQp3aWR0aD0xMikgKGFjdHVhbCB0aW1lPTAuMDAyLi4w LjAwMiByb3dzPTEgbG9vcHM9MTAwMDAwKQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGlk ID0gdDEuaWQpDQogICAgICAgICAgICAgICBGaWx0ZXI6ICgodDEudjEgPSB2MSkgQU5EICh0MS52 MiA9IHYyKSkNCiAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgaWR4X3NzX3RlbXBfdGFibGUy IG9uIHNzX3RlbXBfdGFibGUyIHQyIAooY29zdD0wLjA2Li4wLjA3IHJvd3M9MSB3aWR0aD00KSAo YWN0dWFsIHRpbWU9MC4wMDEuLjAuMDAxIHJvd3M9MQpsb29wcz0xMDAwMDApDQogICAgICAgICBJ bmRleCBDb25kOiAoaWQgPSBkLmlkKQ0KICAgICAgICAgSGVhcCBGZXRjaGVzOiAyMjYNCiBQbGFu bmluZyBUaW1lOiAwLjgxNSBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAzNjguMDc4IG1zDQooMTIgcm93 cykNCmBgYA0KDQpJdCBsb29rcyBsaWtlIHBsYW5uZXIgYnkgZGVmYXVsdCBjYW4gbm90IGZpbmQg YmVzdCBwbGFuIGluIHRlcm1zIG9mCmVzdGltYXRlZCBjb3N0LiBTZWNvbmQgcGxhbiBpcyBjaGVh cGVyLiBJdCBpcyBhbHNvIG11Y2ggbW9yZSBlZmZlY3RpdmUKKDM2OG1zIHZzIDU0MjIyM21zKS4g QW5kIEkgYmVsaWV2ZSB0aGF0IHVzaW5nIGBTZXEgU2NhbmAgb24gYHNzX3RlbXBfdGFibGUxYApi dXQgYEluZGV4IE9ubHkgU2NhbmAgb24gYHNzX3RlbXBfdGFibGUyYCBzaG91bGQgcHJvZHVjZSBl dmVuIGNoZWFwZXIgcGxhbiwKYnV0IEkgZG8gbm90IGtub3cgaG93IHRvIGZvcmNlIHBsYW5uZXIg dG8gZmluZCBpdC4NCg0KSSBzdWJtaXQgYSBidWcsIGJlY2F1c2UgdGhpcyBiZWhhdmlvciBkb2Vz IG5vdCBtYXRjaCB0aGUgZG9jczoNCmBgYA0KVGhlIHRhc2sgb2YgdGhlIHBsYW5uZXIvb3B0aW1p emVyIGlzIHRvIGNyZWF0ZSBhbiBvcHRpbWFsIGV4ZWN1dGlvbiBwbGFuLgpbLi4uXSBJZiBpdCBp cyBjb21wdXRhdGlvbmFsbHkgZmVhc2libGUsIHRoZSBxdWVyeSBvcHRpbWl6ZXIgd2lsbCBleGFt aW5lCmVhY2ggb2YgdGhlc2UgcG9zc2libGUgZXhlY3V0aW9uIHBsYW5zLCB1bHRpbWF0ZWx5IHNl bGVjdGluZyB0aGUgZXhlY3V0aW9uCnBsYW4gdGhhdCBpcyBleHBlY3RlZCB0byBydW4gdGhlIGZh c3Rlc3QuDQpgYGANCg0KQW5vdGhlciB0aGluZyBpcyB0aGF0IHRoZXJlIGlzIGh1Z2UgbnVtYmVy IG9mIHJvd3MgcmVtb3ZlZCBieSBqb2luIGZpbHRlcgooNDk5OTk1MDAwMCkgYW5kIGl0IGxvb2tz IGxpa2UgaXQgaXMgbm90IHRha2VuIGludG8gYWNjb3VudCB3aGVuIGNhbGN1bGF0aW5nCmVzdGlt YXRlZCBjb3N0IG9mIGZpcnN0IHBsYW4gKDczNzQ0Ni4wMCkuIFRoaXMgbWlnaHQgYmUgbW9yZSBp bXBvcnRhbnQKcHJvYmxlbSwgYnV0IGl0IGRvZXMgbm90IGxvb2sgbGlrZSBhIGJ1Zy4NCg0KT3Jp Z2luYWwgcHJvYmxlbSBoYXBwZW5lZCBvbiBQRyAxMy43LiANCkkgd2FzIGFibGUgdG8gcmVwcm9k dWNlIGl0IHdpdGggYXR0YWNoZWQgc2NyaXB0IG9uIGZyZXNobHkgaW5zdGFsbGVkIFBHIDE0LjQK b24gVWJ1bnR1LgoK --===============7318042545802842831==--