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 1slgcg-000aiK-8d for pgsql-committers@arkaria.postgresql.org; Wed, 04 Sep 2024 03:23:58 +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 1slgce-003FGU-S9 for pgsql-committers@arkaria.postgresql.org; Wed, 04 Sep 2024 03:23:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slgZi-003E2r-Ff for pgsql-committers@lists.postgresql.org; Wed, 04 Sep 2024 03:20:54 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slgZd-0002yt-Ut for pgsql-committers@lists.postgresql.org; Wed, 04 Sep 2024 03:20:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=IQ6+qK3EmXYFbGK2KVtIwhl/kETUofbpSUhA1qeTgn8=; b=ZnWyWIunKcstT4KllFE/kCwSSN vCRuVfrLev6mEO/edupEDz4Ith/e5sBOyHDJhSs5Fftz8HJHtMaR2gaFsalyy0rHANyakfUTa/T3q BrdgV17Oi9Q4usXFm6nwS2rqcHqRhDz8LmzOeYBhwoD3z8IYIp6LZBkNmhoBQYkUUkSA2aszzLlfp euCWSIF8Xzp9mB0pF/LUXJShJrks2puU/Fc/NOtrEaqSBKPc4xY3sfyMHS/rRk+Ke8fzFRny/W+aV oBNNxIin0yqPr9+M+J7uK5scGyfZuC6Em2lRlMj/SX0f/KenRA+IYzAj8c9qfud6GzrnzuJFUBHj+ o6MNPOLg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slgZc-0009jt-JP for pgsql-committers@lists.postgresql.org; Wed, 04 Sep 2024 03:20:49 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1slgZb-0003Ur-D6 for pgsql-committers@lists.postgresql.org; Wed, 04 Sep 2024 03:20:48 +0000 Content-Type: multipart/mixed; boundary="===============4300504297108404562==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid unnecessary post-sort projection X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 04 Sep 2024 03:20:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4300504297108404562== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgdW5uZWNlc3NhcnkgcG9zdC1zb3J0IHByb2plY3Rpb24KCldoZW4gZ2VuZXJhdGluZyBw YXRocyBmb3IgdGhlIE9SREVSIEJZIGNsYXVzZSwgb25lIHRoaW5nIHdlIG5lZWQgdG8KZW5zdXJl IGlzIHRoYXQgdGhlIG91dHB1dCBwYXRocyBwcm9qZWN0IHRoZSBjb3JyZWN0IGZpbmFsX3Rhcmdl dC4gIFRvCmFjaGlldmUgdGhpcywgaW4gY3JlYXRlX29yZGVyZWRfcGF0aHMsIHdlIGNvbXBhcmUg dGhlIHBhdGh0YXJnZXQgb2YKZWFjaCBnZW5lcmF0ZWQgcGF0aCB3aXRoIHRoZSBnaXZlbiAndGFy Z2V0JywgYW5kIGFkZCBhIHBvc3Qtc29ydApwcm9qZWN0aW9uIHN0ZXAgaWYgdGhlIHR3byB0YXJn ZXRzIGRvIG5vdCBtYXRjaC4KCkN1cnJlbnRseSB3ZSBwZXJmb3JtIGEgc2ltcGxlIHBvaW50ZXIg Y29tcGFyaXNvbiBiZXR3ZWVuIHRoZSB0d28KdGFyZ2V0cy4gIEl0IHR1cm5zIG91dCB0aGF0IHRo aXMgaXMgbm90IHN1ZmZpY2llbnQuICBFYWNoIHNvcnRlZF9wYXRoCmdlbmVyYXRlZCBpbiBjcmVh dGVfb3JkZXJlZF9wYXRocyBpbml0aWFsbHkgcHJvamVjdHMgdGhlIGNvcnJlY3QKdGFyZ2V0IHJl cXVpcmVkIGJ5IHRoZSBwcmVjZWRpbmcgc3RlcHMgb2Ygc29ydC4gIElmIGl0IGlzIHRoZSBzYW1l CnBvaW50ZXIgYXMgc29ydF9pbnB1dF90YXJnZXQsIHBvaW50ZXIgY29tcGFyaXNvbiBzdWZmaWNl cywgYmVjYXVzZQpzb3J0X2lucHV0X3RhcmdldCBpcyBhbHdheXMgaWRlbnRpY2FsIHRvIGZpbmFs X3RhcmdldCB3aGVuIG5vCnBvc3Qtc29ydCBwcm9qZWN0aW9uIGlzIG5lZWRlZC4KCkhvd2V2ZXIs IHNvcnRlZF9wYXRoJ3MgaW5pdGlhbCBwYXRodGFyZ2V0IG1heSBub3QgYmUgdGhlIHNhbWUgcG9p bnRlcgphcyBzb3J0X2lucHV0X3RhcmdldCwgYmVjYXVzZSBpbiBhcHBseV9zY2Fuam9pbl90YXJn ZXRfdG9fcGF0aHMsIGlmCnRoZSB0YXJnZXQgdG8gYmUgYXBwbGllZCBoYXMgdGhlIHNhbWUgZXhw cmVzc2lvbnMgYXMgdGhlIGV4aXN0aW5nCnJlbHRhcmdldCwgd2Ugb25seSBpbmplY3QgdGhlIHNv cnRncm91cHJlZiBpbmZvIGludG8gdGhlIGV4aXN0aW5nCnBhdGh0YXJnZXRzLCByYXRoZXIgdGhh biBjcmVhdGUgbmV3IHByb2plY3Rpb24gcGF0aHMuICBBcyBhIHJlc3VsdCwKcG9pbnRlciBjb21w YXJpc29uIGluIGNyZWF0ZV9vcmRlcmVkX3BhdGhzIGlzIG5vdCByZWxpYWJsZS4KCkluc3RlYWQs IHdlIGNhbiBjb21wYXJlIFBhdGhUYXJnZXQuZXhwcnMgdG8gZGV0ZXJtaW5lIHdoZXRoZXIgYQpw cm9qZWN0aW9uIHN0ZXAgaXMgbmVlZGVkLiAgSWYgdGhlIGV4cHJlc3Npb25zIG1hdGNoLCB3ZSBj YW4gYmUKY29uZmlkZW50IHRoYXQgYSBwb3N0LXNvcnQgcHJvamVjdGlvbiBpcyBub3QgcmVxdWly ZWQuCgpJdCBjb3VsZCBiZSBhcmd1ZWQgdGhhdCB0aGlzIGNoYW5nZSBhZGRzIGV4dHJhIGNoZWNr IGNvc3QgZWFjaCB0aW1lIHdlCmRlY2lkZSB3aGV0aGVyIGEgcG9zdC1zb3J0IHByb2plY3Rpb24g aXMgbmVlZGVkLiAgSG93ZXZlciwgYXMKZXhwbGFpbmVkIGluIGFwcGx5X3NjYW5qb2luX3Rhcmdl dF90b19wYXRocywgYnkgYXZvaWRpbmcgdGhlIGNyZWF0aW9uCm9mIHByb2plY3Rpb24gcGF0aHMs IHdlIHNhdmUgZWZmb3J0IGJvdGggaW1tZWRpYXRlbHkgYW5kIGF0IHBsYW4KY3JlYXRpb24gdGlt ZS4gIFRoaXMsIEkgdGhpbmssIGp1c3RpZmllcyB0aGUgZXh0cmEgY2hlY2sgY29zdC4KClRoZXJl IGFyZSB0d28gZW5zdWluZyBwbGFuIGNoYW5nZXMgaW4gdGhlIHJlZ3Jlc3Npb24gdGVzdHMsIGJ1 dCB0aGV5Cmxvb2sgcmVhc29uYWJsZSBhbmQgYXJlIGV4YWN0bHkgd2hhdCB3ZSBhcmUgZml4aW5n IGhlcmUuICBTbyBubwphZGRpdGlvbmFsIHRlc3QgY2FzZXMgYXJlIGFkZGVkLgoKTm8gYmFja3Bh dGNoIGFzIHRoaXMgY291bGQgcmVzdWx0IGluIHBsYW4gY2hhbmdlcy4KCkF1dGhvcjogUmljaGFy ZCBHdW8KUmV2aWV3ZWQtYnk6IFBldGVyIEVpc2VudHJhdXQsIERhdmlkIFJvd2xleSwgVG9tIExh bmUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0OFRvc1N2bW56ODg2NjNf MnlnM2hmZU9Gc3MtSjJQdG5FTkRINkpfckxuUlFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0t LS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcv Y29tbWl0ZGlmZi85NjI2MDY4ZjEzMzM4Zjc5YmExODNiNGNmM2M5NzVlMjJjOThjNTc1CgpNb2Rp ZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFu bmVyLmMgICAgICAgICAgICAgfCAxNCArKysrKysrKystLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvc2VsZWN0X2Rpc3RpbmN0X29uLm91dCB8IDI2ICsrKysrKysrKysrLS0tLS0tLS0tLS0t LQoyIGZpbGVzIGNoYW5nZWQsIDIyIGluc2VydGlvbnMoKyksIDE4IGRlbGV0aW9ucygtKQoK --===============4300504297108404562==--