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 1ol86W-0007M2-Kb for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Oct 2022 12:23:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ol86V-0002Ua-6t for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Oct 2022 12:23:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ol68I-0000ZT-HF for pgsql-bugs@lists.postgresql.org; Wed, 19 Oct 2022 10:17:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ol68F-0004YY-R8 for pgsql-bugs@lists.postgresql.org; Wed, 19 Oct 2022 10:17:05 +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=FS0PSMkCV+eYoXyQdBzRW7g86SpD2dYZC+9wi6Ft4kk=; b=rPnGBTO5HBiTDqdTkQ0Mnazxo5 1EBBWSoPxggOAJH8jf+fmB4+pico30Am6wQ/iXEBdvCSEThSLrEOduMJ4Iv6aeUCOjhxB27De9Pz9 bMFl2fiXYir3NOslb2jKvmsHxJt3GERRSqz1x4mmklExL0BxCHrBL/ScW3V1bhWK1qxLh3ZiKGr22 tLhkpqBnypCFlKdoPy+gzJpYOonxknt6sPT0tirEWriI2wjq2/r9LNzVCTAhKUce+WoIfsup/1JGQ 9sUrgNt+nzZxsYyk7ZPL82iE/7CIotvRvMIQVcq94p49D0Ple6ANhKj/HHqqIVQv83I5fcCvaUYbR SwWOXI5g==; 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 1ol68F-00081c-CE for pgsql-bugs@lists.postgresql.org; Wed, 19 Oct 2022 10:17:03 +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 1ol68E-009ua5-0W for pgsql-bugs@lists.postgresql.org; Wed, 19 Oct 2022 10:17:02 +0000 Content-Type: multipart/mixed; boundary="===============2819947734904180307==" MIME-Version: 1.0 Subject: BUG #17651: Possible optimization for sort on not nullable field (indexed) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: d_van_rietschoten@hotmail.com Reply-To: d_van_rietschoten@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 19 Oct 2022 10:16:42 +0000 Message-ID: <17651-8b80b26bdf115df0@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 --===============2819947734904180307== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY1MQpMb2dnZWQgYnk6ICAgICAgICAgIERpbWFyIHZhbiBSaWV0c2No b3RlbgpFbWFpbCBhZGRyZXNzOiAgICAgIGRfdmFuX3JpZXRzY2hvdGVuQGhvdG1haWwuY29tClBv c3RncmVTUUwgdmVyc2lvbjogMTQuNApPcGVyYXRpbmcgc3lzdGVtOiAgIFVzaW5nIGdvb2dsZSBj bG91ZHNxbApEZXNjcmlwdGlvbjogICAgICAgIAoKSXQgaXMgbm90IGEgYnVnLCBidXQgbWlnaHQg YmUgYW4gb3Bwb3J0dW5pdHkgZm9yIHRoZSBvcHRpbWl6ZXIuDQoNCkkgaGF2ZSBhIHRhYmxlIHdp dGg6DQpDUkVBVEUgVEFCTEUgdGVzdA0KKA0KICAgcGVyaW9kIHRleHQgTk9UIE5VTEwsDQogICBy ZXRhaWxlcl9pZCBpbnQgTk9UIE5VTEwsDQogICBvcmRlcl9saW5lcyBpbnQgTk9UIE5VTEwNCik7 DQoNCkNSRUFURSBJTkRFWCBpeF90ZXN0IE9OIHRlc3QocGVyaW9kLCAgcmV0YWlsZXJfaWQsIG9y ZGVyX2xpbmVzKTsNCg0KVGhlIHRhYmxlIGNvbnRhaW5zIDE3MC42MzIuNDA3IHJlY29yZHMuDQoN CldoZW4gcGVyZm9ybWluZyB0aGUgcXVlcnk6DQpleHBsYWluIGFuYWx5emUNCnNlbGVjdCAqIGZy b20gdGVzdCANCndoZXJlIHJldGFpbGVyX2lkID0gOnJldGFpbGVySWQgYW5kIHBlcmlvZCA9IDpw ZXJpb2QNCm9yZGVyIGJ5IG9yZGVyX2xpbmVzIGRlc2M7DQoNCkkgc2VlIGEgcXVlcnkgcGxhbjoN CkluZGV4IFNjYW4gQmFja3dhcmQgdXNpbmcgaXhfdGVzdCBvbiB0ZXN0ICAoY29zdD0wLjU3Li42 OTQyMjMuMjAKcm93cz0yMjg3MzE5IHdpZHRoPTI4KSAoYWN0dWFsIHRpbWU9MC4wMzAuLjcyNi42 NjYgcm93cz0yMTg5OTcyIGxvb3BzPTEpDQogIEluZGV4IENvbmQ6ICgocGVyaW9kID0gJ0xBU1Rf V0VFSyc6OnRleHQpIEFORCAocmV0YWlsZXJfaWQgPSAwKSkNCg0KSG93ZXZlciB3aGVuIHVzaW5n IHRoZSBudWxscyBsYXN0IGluIHRoZSBvcmRlciBieSAob24gYSBub3QgbnVsbGFibGUKY29sdW1u KSwgSSBnZXQgdGhpcyBxdWVyeSBwbGFuOg0KU29ydCAgKGNvc3Q9OTk4MzY3Ljg2Li4xMDA0MDg2 LjE1IHJvd3M9MjI4NzMxOSB3aWR0aD0yOCkgKGFjdHVhbAp0aW1lPTE1MjAuMjg4Li4xNzk1LjI0 MiByb3dzPTIxODk5NzIgbG9vcHM9MSkNCiAgU29ydCBLZXk6IG9yZGVyX2xpbmVzIERFU0MgTlVM TFMgTEFTVA0KICBTb3J0IE1ldGhvZDogZXh0ZXJuYWwgbWVyZ2UgIERpc2s6IDgxNTA0a0INCiAg LT4gIEluZGV4IFNjYW4gdXNpbmcgaXhfdGVzdCBvbiB0ZXN0ICAoY29zdD0wLjU3Li42OTQyMjMu MjAgcm93cz0yMjg3MzE5CndpZHRoPTI4KSAoYWN0dWFsIHRpbWU9MC4wNDEuLjY4OC43MDEgcm93 cz0yMTg5OTcyIGxvb3BzPTEpDQogICAgICAgIEluZGV4IENvbmQ6ICgocGVyaW9kID0gJ0xBU1Rf V0VFSyc6OnRleHQpIEFORCAocmV0YWlsZXJfaWQgPSAwKSkNCg0KKFF1ZXJ5IGlzOg0KIGV4cGxh aW4gYW5hbHl6ZQ0Kc2VsZWN0ICogZnJvbSB0ZXN0IA0Kd2hlcmUgcmV0YWlsZXJfaWQgPSA6cmV0 YWlsZXJJZCBhbmQgcGVyaW9kID0gOnBlcmlvZA0Kb3JkZXIgYnkgb3JkZXJfbGluZXMgZGVzYzsN CikNCg0KRXhwZWN0ZWQ6IGFzIHRoZSBjb2x1bW4gaXMgbm90IG51bGxhYmxlLCB0aGUgaW5kZXgg Y2FuIHN0aWxsIGJlIHVzZWQgYW5kCnRoZXJlIGlzIG5vIG5lZWQgZm9yIHRoZSBzZXBhcmF0ZSBz b3J0Lg0KDQpTb21lIGJhY2tncm91bmQ6IHRoaXMgcXVlcnkgaXMgZHluYW1pY2FsbHkgZ2VuZXJh dGVkLiBTb21lIGNvbHVtbnMgYXJlCm51bGxhYmxlLCBvdGhlcnMgYXJlIG5vdC4gTWFraW5nIHRo aXMgZGlzdGluY3Rpb24gaW4gdGhlIGNvZGUgdGhhdCBnZW5lcmF0ZXMKdGhlIHF1ZXJ5IG1ha2Vz IHRoZSBjb2RlIGhhcmRlciB0byBtYWludGFpbi4gSXQgd291bGQgaGVscCBpZiB3ZSBjYW4gbGVh dmUKdGhpcyB0byB0aGUgb3B0aW1pemVyIGluc3RlYWQuCgo= --===============2819947734904180307==--