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 1rtDq3-00DFOK-OE for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Apr 2024 21:44:40 +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 1rtDq2-00Grr5-Bd for pgsql-bugs@arkaria.postgresql.org; Sat, 06 Apr 2024 21:44:38 +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 1rtBVT-00FR1R-Kk for pgsql-bugs@lists.postgresql.org; Sat, 06 Apr 2024 19:15:15 +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 1rtBVK-0017CU-K7 for pgsql-bugs@lists.postgresql.org; Sat, 06 Apr 2024 19:15: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=NxtqpCQgzoPzjwx/m4lM0rDQwCaK022f6k7wtRONw0s=; b=WTIJCUOoBhUAdgoFctbb3boFCg S+YqkOGfQAiy+Y7sn9nw4/wNc+3gPd9Rj2AtGznTiE6zeob3TFda5l4dQQj5q+/c6zsorD4mDZl80 Tnzx5eyxCRK8o8ELoEHO9sg+D0F+ueC1Ffw5f2+cPl8S7ThzNhRrk5yArMencWC50PHlYSOPN4RwM n58SsPrsqhX0QZcqeVF53Fkr5fmcdQR1SW44wH8qTKlgXLVuWmg/ohlPUUvp/n1SUpovcO9ZEuOCn 4I1EQz/PiKt3eJyCT6je++n4nhI5oFayPpLnsR8eFINi8Mpmb57jR4cvRPGpAWiT1mz7dHsq9HKOd 639hp0Qw==; 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 1rtBVI-002ZD2-TM for pgsql-bugs@lists.postgresql.org; Sat, 06 Apr 2024 19:15: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 1rtBVG-009xI4-Oj for pgsql-bugs@lists.postgresql.org; Sat, 06 Apr 2024 19:15:03 +0000 Content-Type: multipart/mixed; boundary="===============1527233833740601701==" MIME-Version: 1.0 Subject: BUG #18423: suboptimal query plan is used when ordering by an indexed field with limit To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maojiayin@gmail.com Reply-To: maojiayin@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 06 Apr 2024 19:14:03 +0000 Message-ID: <18423-f063cbf58ca6a294@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 --===============1527233833740601701== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQyMwpMb2dnZWQgYnk6ICAgICAgICAgIEppYXlpbiBNYW8KRW1haWwg YWRkcmVzczogICAgICBtYW9qaWF5aW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTUu MApPcGVyYXRpbmcgc3lzdGVtOiAgIGFsbApEZXNjcmlwdGlvbjogICAgICAgIAoKV2UgZm91bmQg dGhhdCB3aGVuIHdlIHVzZSBPUkRFUiBCWSBvbiBhbiBpbmRleGVkIGZpZWxkIHdpdGggYSBzbWFs bCBsaW1pdAp2YWx1ZSB0aGUgaW5kZXggb24gdGhlIG9yZGVyZWQgZmllbGQgaXMgYWx3YXlzIHVz ZWQsIGxlYWRpbmcgdG8gbG9uZwpleGVjdXRpb24gdGltZSB3aGVuIHRoZSBvcmRlcmVkIGZpZWxk IGRvZXMgbm90IGhhdmUgZ29vZCBzZWxlY3Rpdml0eS4KVXN1YWxseSB0aGUgbWFpbiBwdXJwb3Nl IGZvciB1c2luZyBPUkRFUiBCWSB3aXRoIExJTUlUIGlzIHRvIG1ha2Ugc3VyZSB0aGUKc2VhcmNo IHJlc3VsdCBpcyBzdGFibGUuIEl0IGlzIHRoZSBjb25kaXRpb25zIGluIHRoZSBxdWVyeSAodGhl IGV4cHJlc3Npb25zCmJldHdlZW4gV0hFUkUgYW5kIE9SREVSIEJZKSB0aGF0IGFwcGxpY2F0aW9u IGRldmVsb3BlcnMgd2FudCBxdWVyeSBwbGFubmVyCnRvIGNob29zZSB0byBzZWxlY3QgdGFyZ2V0 ZWQgcm93cyBhcyBhIGZpcnN0IHN0ZXAuIA0KDQpGb3IgZXhhbXBsZSwgb3VyICJ1c2VyIiB0YWJs ZSBoYXMgYW4gaWQgcHJpbWFyeSBrZXksIGFuICJvcmdfaWQiIGNvbHVtbiBhbmQKYSAiZGlzYWJs ZWQiIGNvbHVtbi4gVGhlIHRhYmxlIGhhcyBtaWxsaW9ucyBvZiByb3dzIGFuZCBmb3IgZWFjaCBv cmdfaWQKdGhlcmUgaXMgb25seSB1c3VhbGx5IGEgZmV3IGh1bmRyZWQgcm93cy4gV2UgaGF2ZSBh biBpbmRleCBvbiAob3JnX2lkLApkaXNhYmxlZCkgYW5kIHRoYXQgaW5kZXggY2FuIHF1aWNrbHkg c2VsZWN0IGEgZmV3IGh1bmRyZWQgcm93cyBmcm9tIHRoZQptaWxsaW9uLXJvdyB0YWJsZS4gV2Ug d2FudCB0byBmaW5kIHRoZSByb3cgd2l0aCB0aGUgc21hbGxlc3QgaWQgd2l0aCBhIGdpdmVuCm9y Z19pZCwgc28gd2UgdXNlICJPUkRFUiBCWSBpZCBMSU1JVCAxIiBhcyBvcmRlciBjb25kaXRpb24u IFRoZSBxdWVyeSBwbGFuCnVzZXMgdGhlIGJ0cmVlIGluZGV4IG9uIHRoZSBpZCBmaWVsZCBzaW5j ZSBpdCBpcyB0aGUgb3JkZXJlZCBmaWVsZCwgY2F1c2luZwp0aGUgZXhlY3V0aW9uIHRvIGZpcnN0 IHNlZSBhIGxvdCBtb3JlIHJvd3MgdGhhbiBpdCBuZWVkcy4gSW4gdGhlIGZvbGxvd2luZwpxdWVy eSBwbGFuLCBpdCBoYXMgdG8gcmVtb3ZlIDU5NjAwMyByb3dzIGJ1dCB0aGUgb3JnIG9ubHkgaGFz IGEgZmV3IGh1bmRyZWQKcm93cywgd2hpY2ggY2FuIGJlIHNlZW4gaW4gdGhlIHNlY29uZCBxdWVy eSBwbGFuIGJlbG93LiANCg0KYGBgDQpleHBsYWluIGFuYWx5emUgU0VMRUNUICogRlJPTSAidXNl ciIgV0hFUkUgb3JnX2lkID0gMTIzNDU2IEFORCBkaXNhYmxlZCA9CmZhbHNlIE9SREVSIEJZIGlk IExJTUlUIDE7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IExpbWl0ICAoY29zdD0wLjQzLi4zNjYuODMgcm93cz0xIHdpZHRoPTIzMikgKGFjdHVhbCB0aW1l PTM1Ny4zMTkuLjM1Ny4zMjAKcm93cz0xIGxvb3BzPTEpDQogICAtPiAgSW5kZXggU2NhbiB1c2lu ZyB1c2VyX3BrZXkgb24gdXNlciAgKGNvc3Q9MC40My4uMzA2NjczLjg0IHJvd3M9ODM3CndpZHRo PTIzMikgKGFjdHVhbCB0aW1lPTM1Ny4zMTkuLjM1Ny4zMTkgcm93cz0xIGxvb3BzPTEpDQogICAg ICAgICBGaWx0ZXI6ICgoTk9UIGRpc2FibGVkKSBBTkQgKG9yZ19pZCA9IDEyMzQ1NikpDQogICAg ICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA1OTYwMDMNCiBQbGFubmluZyBUaW1lOiAwLjg4 NSBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAzNTcuMzczIG1zDQpgYGANCg0KSWYgdGhlIGluZGV4IG9m IChvcmdfaWQsIGRpc2FibGVkKSBpcyB1c2VkIGJ5IHRyaWNraW5nIHRoZSBxdWVyeSBwbGFubmVy CndpdGggIk9SREVSIEJZIGlkICsgMCBMSU1JVCAxIiwgdGhlIHF1ZXJ5IHRpbWUgZHJvcHMgZnJv bSAzNTdtcyB0byAxLjVtcy4NCmBgYA0KRVhQTEFJTiBhbmFseXplIFNFTEVDVCAqIEZST00gInVz ZXIiIFdIRVJFIG9yZ19pZCA9IDEyMzQ1NiBhbmQgZGlzYWJsZWQgPQpmYWxzZSBvcmRlciBieSB1 c2VyLmlkICsgMCBsaW1pdCAxOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkKUExBTg0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBMaW1pdCAgKGNvc3Q9MzE0NS42MS4uMzE0NS42MiBy b3dzPTEgd2lkdGg9MjM2KSAoYWN0dWFsIHRpbWU9MS41MTMuLjEuNTE0CnJvd3M9MSBsb29wcz0x KQ0KICAgLT4gIFNvcnQgIChjb3N0PTMxNDUuNjEuLjMxNDcuNzEgcm93cz04Mzcgd2lkdGg9MjM2 KSAoYWN0dWFsCnRpbWU9MS41MTIuLjEuNTEzIHJvd3M9MSBsb29wcz0xKQ0KICAgICAgICAgU29y dCBLZXk6ICgoaWQgKyAwKSkNCiAgICAgICAgIFNvcnQgTWV0aG9kOiB0b3AtTiBoZWFwc29ydCAg TWVtb3J5OiAyNWtCDQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX29yZ19kaXNh YmxlZF9pZHggb24gdXNlciAKKGNvc3Q9MC40My4uMzE0MS40MyByb3dzPTgzNyB3aWR0aD0yMzYp IChhY3R1YWwgdGltZT0wLjA0OS4uMS40MDcgcm93cz0xNjYKbG9vcHM9MSkNCiAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6ICgob3JnX2lkID0gMTIzNDU2KSBBTkQgKGRpc2FibGVkID0gZmFsc2Up KQ0KIFBsYW5uaW5nIFRpbWU6IDAuOTA4IG1zDQogRXhlY3V0aW9uIFRpbWU6IDEuNTgwIG1zDQpg YGAKCg== --===============1527233833740601701==--