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 1rxkys-00BYwh-Ej for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Apr 2024 09:56:30 +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 1rxkyr-000d4x-44 for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Apr 2024 09:56:29 +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 1rxeed-00Dwo2-QL for pgsql-bugs@lists.postgresql.org; Fri, 19 Apr 2024 03:11:11 +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 1rxeeY-001j9A-Vt for pgsql-bugs@lists.postgresql.org; Fri, 19 Apr 2024 03:11: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=Y3Of8AGOk6vtBX1q30mboYB37FRjZjxLmgXNkpaW72s=; b=en48hlsCr0IDoDAjt/OWkAhwl9 aomeuVh/CFJ+kv9QcKUUr1SoCbIzsPWD2FO/RcWBL8W4RAhsXHTMvHXUn9pZKHQnkAdcOX8zUZG2r lyZMe6p7OqY5gg8+nOeWkNu7hpQc/N5fbnH48T6vBS0r4+3qU8IKKCQmzZZx5V7/K2ofZqCBdiqp1 WFP7xNdi0Raen0bo2kJ4i6GQw7tcNXAABlKFvRXVBAywf7G80nGWpUaNviTG/LPP/yFCmswufMbpB Sun7cm1AiE7ScG/KlGxTAQc10FNFFpoDniTpz5KoxyXkXvwWPs+DTHenALmExAHMVY2ZWEhpbJak4 NP7Rf0zg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rxeeW-008wF3-6p for pgsql-bugs@lists.postgresql.org; Fri, 19 Apr 2024 03:11: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 1rxeeT-00CWEy-Vp for pgsql-bugs@lists.postgresql.org; Fri, 19 Apr 2024 03:11:02 +0000 Content-Type: multipart/mixed; boundary="===============0655489016470972078==" MIME-Version: 1.0 Subject: BUG #18442: Unnecessary Sort operator in indexScan Plan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hu_yajun@qq.com Reply-To: hu_yajun@qq.com, pgsql-bugs@lists.postgresql.org Date: Fri, 19 Apr 2024 03:10:24 +0000 Message-ID: <18442-aca4c9134416990e@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 --===============0655489016470972078== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ0MgpMb2dnZWQgYnk6ICAgICAgICAgIHlhanVuIEh1CkVtYWlsIGFk ZHJlc3M6ICAgICAgaHVfeWFqdW5AcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTQuMTEKT3Bl cmF0aW5nIHN5c3RlbTogICBDZW50T1M3IHdpdGgga2VybmVsIHZlcnNpb24gNS4xMApEZXNjcmlw dGlvbjogICAgICAgIAoKSSBoYXZlIHJlcHJvZHVjZWQgdGhpcyBwcm9ibGVtIGluIFJFTF8xNF8x MSBhbmQgdGhlIGxhdGVzdCBtYXN0ZXIgYnJhbmNoDQooODRkYjlhMGViMTBkZDFkYmVlNmRiNTA5 YzBlNDI3ZmEyMzcxNzdkYykuDQpUaGUgc3RlcHMgdG8gcmVwcm9kdWNlIGFyZSBhcyBmb2xsb3dz Lg0KMS4gLi9jb25maWd1cmUgIC0tZW5hYmxlLWRlYnVnIC0tZW5hYmxlLWRlcGVuZCAtLWVuYWJs ZS1jYXNzZXJ0IENGTEFHUz0tTzANCjIuIG1ha2UgLWo7IG1ha2UgaW5zdGFsbCAtajsgaW5pdGRi IC1EIC4vcHJpbWFyeTsgcGdfY3RsIC1EIC4uL3ByaW1hcnkgLWwNCmxvZ2ZpbGUgc3RhcnQNCjMu IHJ1biBTUUw6DQpgYGANCmNyZWF0ZSB0YWJsZSB0KCBhIGludCwgYiBpbnQpOw0KaW5zZXJ0IGlu dG8gdCBzZWxlY3QgbnVsbCxpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMTAwKWk7DQppbnNlcnQg aW50byB0IHNlbGVjdCBpLGkgZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMDApaTsNCmFuYWx5 emUgdDsNCmNyZWF0ZSBpbmRleCBvbiB0KGEsYik7DQpwb3N0Z3Jlcz0jIGV4cGxhaW4gc2VsZWN0 ICogZnJvbSB0IHdoZXJlIGEgaXMgbnVsbCBvcmRlciBieSBiOyAtLSBuZWVkCnNvcnQNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCiBTb3J0ICAoY29zdD05LjU0Li45LjgwIHJvd3M9MTAzIHdpZHRoPTgpDQogICBT b3J0IEtleTogYg0KICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyB0X2FfYl9pZHggb24gdCAg KGNvc3Q9MC4yOS4uNi4xMCByb3dzPTEwMwp3aWR0aD04KQ0KICAgICAgICAgSW5kZXggQ29uZDog KGEgSVMgTlVMTCkNCig0IHJvd3MpDQoNCnBvc3RncmVzPSMgZXhwbGFpbiBzZWxlY3QgKiBmcm9t IHQgd2hlcmUgYSBpcyBudWxsIG9yZGVyIGJ5IGEsIGI7IC0tIG5vIG5lZWQKc29ydA0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IEluZGV4IE9ubHkgU2NhbiB1c2luZyB0X2FfYl9pZHggb24gdCAgKGNvc3Q9MC4yOS4uNi4xMCBy b3dzPTEwMyB3aWR0aD04KQ0KICAgSW5kZXggQ29uZDogKGEgSVMgTlVMTCkNCigyIHJvd3MpDQoN CnBvc3RncmVzPSMgZXhwbGFpbiBzZWxlY3QgKiBmcm9tIHQgd2hlcmUgYSA9IDEgb3JkZXIgYnkg YjsgLS0gbm8gbmVlZCBzb3J0DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkg UExBTg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSW5kZXggT25seSBTY2FuIHVzaW5nIHRfYV9iX2lkeCBv biB0ICAoY29zdD0wLjI5Li40LjMxIHJvd3M9MSB3aWR0aD04KQ0KICAgSW5kZXggQ29uZDogKGEg PSAxKQ0KKDIgcm93cykNCmBgYA0KDQpJbiBteSB1bmRlcnN0YW5kaW5nLCBpbiB0aGUgZmlyc3Qg U0VMRUNULCBiZWNhdXNlIGEgaXMgYWx3YXlzIE5VTEwsIHRoZQpzY2FubmVkDQpkYXRhIGFjY2Vz cyBieSBJbmRleE9ubHlTY2FuIGlzIHNvcnRlZCBhY2NvcmRpbmcgdG8gYiwgd2hpY2ggbWVhbnMg dGhhdCB0aGUKdXBwZXINClNvcnQgb3BlcmF0b3IgaXMgdW5uZWNlc3Nhcnkgb3ZlcmhlYWQuVGhl IHNlY29uZCBhbmQgdGhpcmQgU0VMRUNUIGFyZSBib3RoCmFzDQpleHBlY3RlZC4gDQoNCkkgdHJp ZWQgdG8gYW5hbHl6ZSB0aGUgY29kZSBhbmQgZm91bmQgdGhhdCB0aGUgRXF1aXZhbGVuY2VDbGFz cyBvZiBjb2x1bW4gYQphbmQgTlVMTA0Kd2FzIG1pc3NpbmcsIHdoaWNoIGNhdXNlZCBidWlsZF9p bmRleF9wYXRoa2V5cyB0byByZXR1cm4gTklMLiBObyBwYXRoa2V5cwptYWtlcyB0aGUNCm9wdGlt aXplciBkZWNpZGUgdGhhdCB0aGUgdXBwZXIgbGF5ZXIgbmVlZGVkIFNvcnQgdG8gZW5zdXJlIHRo YXQgdGhlIGRhdGEKd2FzIGluIG9yZGVyLg0KSSByb3VnaGx5IGtub3cgdGhhdCBpdCBtYXkgYmUg YmVjYXVzZSBOdWxsVGVzdCBpbiB0aGUgY2hlY2tfbWVyZ2Vqb2luYWJsZQpmdW5jdGlvbiBpcw0K bm90IE9wRXhwci4gSXMgaXQgcG9zc2libGUgaGVyZSB0byBnZW5lcmF0ZSBzcGVjaWFsIEVxdWl2 YWxlbmNlQ2xhc3MgZm9yCmNvbHVtbiBhIGFuZA0KTlVMTCB0byBzb2x2ZSB0aGlzIHByb2JsZW0/ DQoNCknigJltIGxvb2tpbmcgZm9yd2FyZCB0byBzb21lb25lIGFuc3dlcmluZyBteSBjb25mdXNp b24sIHRoYW5rIHlvdSB2ZXJ5IG11Y2jvvIEKCg== --===============0655489016470972078==--