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.96) (envelope-from ) id 1voMyG-002Etm-0R for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 14:38:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1voMyF-004BGj-0j for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 14:38:07 +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.96) (envelope-from ) id 1voMyE-004BGb-2j for pgsql-hackers@lists.postgresql.org; Fri, 06 Feb 2026 14:38:06 +0000 Received: from mail-japanwestazolkn19011030.outbound.protection.outlook.com ([52.103.66.30] helo=OS0P286CU010.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1voMyC-00000001NMp-1zzZ for pgsql-hackers@postgresql.org; Fri, 06 Feb 2026 14:38:06 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=ByWKn8ByEfBSXlMtUQEqKWzQS0CgXockyBkjwrg6JTucwhpkIkEP6LXQGdTGYd9Na/pjJCuu5TfwP0lRFmunIiIQjQnRKeJCgB85VdwR7nbkClw6e+WsuJWjhEEX3Ybw8li8BHtVW4y2ZyC1r6PoQz5bdCLQieqtxYnCMs7rIFKZj5WIsoFAH4SbM5naD1YcRkr9PhFk/xZkPXa7V9Ke2Qs7XCJr5OxOD5pVbZK49FN3lInGYCLqeYzj7tYJ1M87XAT9DuUS5uyTcI6e9p0HaHRasCgm5P3DUPQ1R30gWP89mNytdcrwh7sORNy9yOu2h8jpM9/AQ1YJU1xD582y8Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Ku6k8fZ10hBO7B9+ToLGMxFCnvp8yqLKXLyQR7VNFVM=; b=aC/qkXIspBz7OekW0jQVJoISdadc5FB1iCb/2yQR2HvEzMVJgiQBtoNjdGK1QEHFh0LDw3R7SJSb16ZKVulgWuet8pdxt2u+rRJPdBZWZHdUtpQXDt90FTFlsHeVmFKXPsKr+67fENoX2Y/ZuaTn5/WzJbYdYut/vIg5Og+XhNkCaYd2r9f//40AiuLbrWYsfwxkAdVjksFxBLoNnIgDWq2Xh6K02mQEymiuizhT0EISMULD07ev40QoqsHOvbxNaACy9g9KlhiDGe2l/lcdmw0DX5Z2jgLYw8/2dTsbc5VbdSHskrAQYL+LMHtJLzAewJBpOU86yygWlTqbtyWNeA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Ku6k8fZ10hBO7B9+ToLGMxFCnvp8yqLKXLyQR7VNFVM=; b=O3Ceaf2s+XUUimPIVv+S0tOKHC+yUpZVlvfWjrkFNoyFUZJg+2WZK2eYdpJbC11QE8F6t9eyYxpFfO4jgIq55S00c9pDKN9VINbg7Xw8RdXAnQ+9nx/mMozKZ+0Eu+PnuxoelaCnhBY6Bf/3Z3EuiWuAq4XuxEDmTbNAjVrWO0yBXGaARKyXJWdBiL1rCoEX+39Gyj7StZF+PsxDI3Fu2BaubHwdxizrbKapfGeqUTLLseYcUEUOgsxhTJc4RpBzoV0b+G1OCTQ1OXMAa9q1zoXn/X25uqjTar3Sd13to/6kfmaRGnd2JZF2mdCbSB+JUSx9OBto4gf/F46284gCCg== Received: from TYYPR01MB14116.jpnprd01.prod.outlook.com (2603:1096:405:212::9) by TYCPR01MB6733.jpnprd01.prod.outlook.com (2603:1096:400:9e::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9587.15; Fri, 6 Feb 2026 14:37:59 +0000 Received: from TYYPR01MB14116.jpnprd01.prod.outlook.com ([fe80::31dd:4ff2:eea8:c663]) by TYYPR01MB14116.jpnprd01.prod.outlook.com ([fe80::31dd:4ff2:eea8:c663%7]) with mapi id 15.20.9587.013; Fri, 6 Feb 2026 14:37:59 +0000 From: Chengpeng Yan To: Tom Lane , Andres Freund CC: PostgreSQL-development , David Rowley Subject: Re: Unfortunate pushing down of expressions below sort Thread-Topic: Unfortunate pushing down of expressions below sort Thread-Index: AQHcluFis0QE5NlnU0Sg29X/QGMp3LV0zPyAgAANy4CAAOPCAA== Date: Fri, 6 Feb 2026 14:37:59 +0000 Message-ID: <988146DB-C16A-487C-8C39-656C702EF4E2@Outlook.com> References: <1668738.1770336789@sss.pgh.pa.us> <1674012.1770339751@sss.pgh.pa.us> In-Reply-To: <1674012.1770339751@sss.pgh.pa.us> Accept-Language: zh-CN, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYYPR01MB14116:EE_|TYCPR01MB6733:EE_ x-ms-office365-filtering-correlation-id: 86bef01c-b2f1-4ae2-9b84-08de658d531f x-microsoft-antispam: BCL:0;ARA:14566002|15080799012|19110799012|41001999006|8060799015|8062599012|8022599003|31061999003|461199028|440099028|3412199025|102099032; x-microsoft-antispam-message-info: =?utf-8?B?aStkYzFvdXFXaEJKM3NpS09pMDNJRS9TL2Z2V1VocnhPOGxIdjIzU1NzdUhp?= =?utf-8?B?TUdjRkI3c1dxSDhaQnVVTlZQOGNrMURsdzQrdEZLb1BCYkFxODhQK3ViVkxZ?= =?utf-8?B?TmtpTnhJRFZ0UGVCY2Y2YmNoU0g0eVFBS3c3RndGUngyTW9URlJWMGtCZzNJ?= =?utf-8?B?cDUrKzRUdmlVdUFzUEFZVUhQNndlR2gxUnowVEVUT2FNendIM0FXNUFUUWtZ?= =?utf-8?B?ZGtNSkhmdnpyT0VLTzRTdlJHc0x2OGg4d1FVdU5rdUdrcGF3eEk0d1ErTjNM?= =?utf-8?B?TXhhR29qTkdWRWFnRC9NRGdJb2NyZXdmeVIrN0VtQXM4SEZSeDhCT084Qk42?= =?utf-8?B?Sk8xNk5jSmdzVk4wT0x3a2hGZlpQTVpoSzNGK3RWMUFLc3IzQ2YzbTcydHpM?= =?utf-8?B?MnphNDFVUUNMblRoT1JvRDZJK3FKM0pZVU51Rnp1R2Z1VUVOY1lZZ1ZUY3Uz?= =?utf-8?B?RVdUSU9qTWhLMGdMVlpzcU9iTnNkT3gwdE1oSVFRR3BJQW9OZzhNV3dCRW0z?= =?utf-8?B?alkzbTBCUXBEN1lTVnFHTGRPMkZGeG1iMjYzWGJyTFkwZllWVmpYWG9XY05v?= =?utf-8?B?KzNPMHM2ZE0wWEtVSW0rUDlralRTa0U3YjM0eDVLYWREVGhQaUNIY1NzaVNo?= =?utf-8?B?MmtMRUdYNFVqU0Q3UVRXRHhzTFZjQ0ZTbWh6U3JRSFhwVTk0bE5Zb2xsSTk0?= =?utf-8?B?NGN1d1pNSnNQTzRiZEh4NWZ5SFNDZUdqbWNLQnhZL2JsUi96UlZBSVRndnpM?= =?utf-8?B?UnBudmJUMnozZStjc01kaWgwOFNmRWJ0QW5WczE2L3dCZmN0WHVST0o2Z1N4?= =?utf-8?B?bi9Bb3E0Y0VscGJNZFEzSGEvL0tRSFBSbWMvUDV3N2w4Q3lRVHpjU0hUaktQ?= =?utf-8?B?b3dKYjdsRUFaVWEyK1JmckVrMU1mTnpKemZBT3RDMFdzYS9ZNFRqMnlxWmJT?= =?utf-8?B?T2d3Z2JmcFRWQmx0ZGlKeWdyVm5BWjd4YXlsdHhHODFNUDFXak9seWV1QVFu?= =?utf-8?B?VGlpd2l1M09pRVRuaEw0cHF4QkdtSVd3OEZKQzFnUC9jbjMzcXZON3BacStk?= =?utf-8?B?eG9KZUw5SjIzbUEwazh6TTBxTmRpVWNiR3ZaaUF0anRKblRMK05OQzE0YlBD?= =?utf-8?B?dW5KajBHaWhsS01Id3hucWJjRU1FVTRSUFA3QjhMMThhbTBWVHlSRVBxVC9w?= =?utf-8?B?SWtaMlpnZnpTd0FxTHZEaFlSa3FmdVByVmhCUGY5VE1nK0doSUJrb3NLeXFV?= =?utf-8?B?cnI1cFN6MVNzakdiaFJsZURDTFkvY2R6T2VOTVN4bXkrTTNQMENUbGo2dmJN?= =?utf-8?B?dVpadVpqS3NSc3Z2dGo1REROdjJJT2tuZmpqTHRXTUNpVDk0VTJEZy9td0NU?= =?utf-8?B?THo3Ny9PWlJZUjZ2akY1TVdRT1FPM05udzBlNGxHNUlyeUtvdGJ4MU1zVUJn?= =?utf-8?B?L252UGN6V0RHRmlJTGlodWJGRzNHTFYzRlc5M00yMVRZNHJDUkVPYm1INlhm?= =?utf-8?B?QTNMVDRMT2JISis0TnhUL3F0UHZFZHNNTDFBaTFOSDNsdDVhRVIvMXlSNE15?= =?utf-8?Q?mxVexkaiwEz6lbUR6pN3m2Hk8=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?L1dXMzJBRHJrc2h6NXZVR080WmU5djFld1Q3UDRTbWZCbmZLaUlIMHNmZGtI?= =?utf-8?B?VEJsbEhGSXc1Y1kwT01wUFVia3VwcjZ6Q2JwUmdPb0dRTzJ3Zm5QeENpai9p?= =?utf-8?B?MXU1QmJ0WDZwR2dYNHVZVU5vQVpoWnhHaGNsb0loV1ZoWEhaSU9jaWRLcEhR?= =?utf-8?B?UU1oZEI2L25CdFgwTEI1bXRNWEZKdGxoUXo4L3FYNDJ0amFhTkhxdURMTUE4?= =?utf-8?B?QkJCMW1mQ3JQRnB1NTRhZUF5Zlc2ZHFCU1dVVi80UXdmcVVURCtlejRoT01F?= =?utf-8?B?VkNMUHJYOUR4d0o1Y0xBZkNwSWp5YjZ3cVVrZ1RnalVqVnlRMmpGb2YzdTJH?= =?utf-8?B?Vlh6ZDE0ZEFwZk14TGxGYTVtb1R6TDFwR0RRclFSb1lqMlpYcUV2dlZsaWtB?= =?utf-8?B?Y2VQTnp2ZnRjcmtDY3Z2b3RVMGg0eERSdklObnM0U0lwQTh6Mmd2NHNTTDdH?= =?utf-8?B?d3g0SWZOQ1QvOHoyakQzTEh3QzA2Z20vUlBIUFowMEhSWlQrRVhNbzhremxu?= =?utf-8?B?OVlDcm9qT0xxUDMvaEs1RkxTNzRMT1BSTElBTTBXc203U1lJMGtNQ0JSNStj?= =?utf-8?B?VzRGWFdKcnpqMXlFeGNSUnVDMk1CQ3FlNlhYR2NURjM1cmVFYzFTRjNFTlF0?= =?utf-8?B?RnBCTFJHS1BnbmhKcCtwT2RWc3RmdEcrdE96dnVvcExna0RDWVNGYmRxQ3Jl?= =?utf-8?B?Znk1M2xiajVvTFZtSlVUcU5EdTZIaU9ud3NHKzdhZDBQVkRJbHNjd0dOYmht?= =?utf-8?B?VHFkOUZDYWZGdmVHajUrcXZtb2RBUzVJWnZOM0phVnBRNyticUVlVy9jUEJX?= =?utf-8?B?aktUZUdzQWFoR0xOL3ArSkdROC85VWd5VUFVY3hEQkVVOGZwTlFsNk42dTJP?= =?utf-8?B?cXZlTHpKc1dJYjBCQ2hhZ3FoSHdmYmV5U1pQYVdsNXNib0tHbmZ1WHBzZUtz?= =?utf-8?B?TkV0K0dIZThUcDdFaFZGRm9pU1MvSzRxM3R2cE1XUHN3NUFMSVBwZkhKTjc2?= =?utf-8?B?K09ZUmRZNlI4YlVtZDFzVE1Lc2V4LytISUpzQWZNb3ZQRTRHM1lEZ096eXBB?= =?utf-8?B?T3pFLy93UVpRd3Ivby9iSmcweFBpKzIvKzV3VUlJOGd6WkN5RVhaL25MM2Y4?= =?utf-8?B?Y295Q0lUWXhaOVdlWHBNWm9MbG1IQTRuZ0d6VkdJRmVpb2ZJVkhOekV6SHl5?= =?utf-8?B?L0o5d1Z4NVdrdXFmdW5lUzNucXlJekVBM2pqZTdnSzhTd25zV3dnVml1Q3VR?= =?utf-8?B?SDM0T0I1VWxvTDcrdTVkQ1JXOXNHQTZTdUQwcDdVbWRqSEJoK0xCSVFKVnRE?= =?utf-8?B?ODZ3SXg1anJYWEpzL1lqMlduZU0yMmZuZXpveTRwcHEzbWhPaXlTYkNTSFRx?= =?utf-8?B?ZTlVZFlwdkJPT3ZMa3lPY3hpWXpKa3krTjBZYkVzR1ZKM3dad3Y1N1N0TmNn?= =?utf-8?B?alM0N21sVWhTeDR3eWFwbXZXaGNXVUppYTROWUR5RTlYcUhuNzZKQ2JLRkxR?= =?utf-8?B?VEsyU0lFT2pJdzdFMFlVOFlZT2lDejg0L1pxNDdvY1VFOGUreDJDaU1pYThk?= =?utf-8?B?SFdRS1hxaHB3a3Q4UmUycXRadm1zMUJPdkk1TlUwaHNnaDFuMjFPRy9ySjRX?= =?utf-8?B?cURmYmFpd3o2bHZKNFVwV2FDS1hTU1NOZW1mZTJBcjhLZDFNTjJWbkxLYTRY?= =?utf-8?B?STRSYVE3M0hYYnlFZmdVeHdyeWhMRTdDYW9lNlVMbmMraFhYMm9jMlUyRXZh?= =?utf-8?B?RnVVdW1CVjB4RnEvYnI4aWxDQkZ1WmRtU2VNWXV3aE42RUFZWjlpTUhoVFRa?= =?utf-8?B?UjN3ODZQaytCM3lMVzR6dXFRd05sdWpoVCs0YVFWUnhrMTlKSW9YamEyRUlq?= =?utf-8?B?cUVwMHlqaWNtR0RrT3Q1QXg1aFBIZWhhNmJFL1NhVElZK2c9PQ==?= Content-Type: text/plain; charset="utf-8" Content-ID: <3E0E2E931212544B9AA9E3E1AEAF964E@jpnprd01.prod.outlook.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYYPR01MB14116.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 86bef01c-b2f1-4ae2-9b84-08de658d531f X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Feb 2026 14:37:59.2415 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB6733 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNCkkgdG9vayBhIGNsb3NlciBsb29rIGF0IG1ha2Vfc29ydF9pbnB1dF90YXJnZXQoKSBp bg0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jLg0KDQpUaGUgY3VycmVudCBo ZXVyaXN0aWNzIG9ubHkgZGVmZXIgdGFyZ2V0bGlzdCBleHByZXNzaW9ucyBwYXN0IGEgU29ydA0K d2hlbiB0aGV5IGFyZTogDQoqIHZvbGF0aWxlLCBvciANCiogc2V0LXJldHVybmluZyAoZHVlIHRv IFNSRiBzeW5jaHJvbml6YXRpb24gY29uc3RyYWludHMpLCBvciANCiogY29uc2lkZXJlZCDigJxl eHBlbnNpdmXigJ0gKGNvc3QgPiAxMCAqIGNwdV9vcGVyYXRvcl9jb3N0KSBhbmQgdGhlcmUgaXMg YQ0KTElNSVQuDQoNCkZ1bmN0aW9ucyBsaWtlIHJlcGVhdCgpIGFuZCBhY2xkZWZhdWx0KCkgaGF2 ZSB0aGUgZGVmYXVsdCBwcm9jb3N0ID0gMSwNCnNvIHRoZXkgZG9u4oCZdCBtZWV0IHRoZSDigJxl eHBlbnNpdmXigJ0gdGhyZXNob2xkIGFuZCB0aGVyZWZvcmUgcmVtYWluIGJlbG93DQp0aGUgU29y dCwgd2hpY2ggaXMgd2hhdCBsZWFkcyB0byB0aGUgdHVwbGUgd2lkdGggaW5mbGF0aW9uIHNlZW4g aW4gdGhlc2UNCmV4YW1wbGVzLg0KDQpHcm91cGluZyBiZWhhdmVzIGRpZmZlcmVudGx5OiBtYWtl X2dyb3VwX2lucHV0X3RhcmdldCgpIHVuY29uZGl0aW9uYWxseQ0KZmxhdHRlbnMgbm9uLWdyb3Vw aW5nIGV4cHJlc3Npb25zIHRvIFZhcnMsIHdoaWNoIGlzIHdoeSByZXBlYXQoKSBlbmRzIHVwDQph Ym92ZSB0aGUgQWdncmVnYXRlIG5vZGUgdGhlcmUuDQoNClRvbSBtZW50aW9uZWQgdGhlIG1kNSh3 aWRlY29sKSBjb3VudGVyZXhhbXBsZSwgd2hlcmUgZXZhbHVhdGluZyB0aGUNCmV4cHJlc3Npb24g YmVmb3JlIHRoZSBzb3J0IGNhbiBhY3R1YWxseSByZWR1Y2UgbWVtb3J5IHVzYWdlLiBUaGUga2V5 DQpkaXN0aW5jdGlvbiBzZWVtcyB0byBiZSB3aGV0aGVyIHRoZSBleHByZXNzaW9uIGRlcGVuZHMg c29sZWx5IG9uIHNvcnQNCmtleXMuDQoNClRoZSBhcHByb2FjaCBJ4oCZbSBleHBlcmltZW50aW5n IHdpdGggaXMgdG8gZGVmZXIgYW4gZXhwcmVzc2lvbiBvbmx5IHdoZW4NCmFsbCB0aGUgVmFycyBp dCBkZXBlbmRzIG9uIGFyZSBzb3J0IGtleXMuIFRoYXQgZ2l2ZXMgdGhlIGRlc2lyZWQNCmJlaGF2 aW9yIGluIGJvdGggY2FzZXM6IA0KKiByZXBlYXQoaSwgMTAwMCkgT1JERVIgQlkgaTogaSBpcyB0 aGUgc29ydCBrZXksIHNvIHdlIGRlZmVyIGFuZCBrZWVwDQp0aGUgc29ydCB0dXBsZXMgbmFycm93 LiANCiogbWQ1KHdpZGVjb2wpIE9SREVSIEJZIGlkOiB3aWRlY29sIGlzIG5vdCBhIHNvcnQga2V5 LCBzbyB3ZSBrZWVwIHRoZQ0KZXhwcmVzc2lvbiBiZWxvdyB0aGUgc29ydCBhbmQgYXZvaWQgY2Fy cnlpbmcgdGhlIHdpZGUgY29sdW1uLg0KDQpUaGlzIHNlZW1zIHRvIGFkZHJlc3MgdGhlIGNhc2Vz IGRpc2N1c3NlZCBpbiB0aGlzIHRocmVhZCBhbmQgc2hvdWxkIGJlDQpsb3ctcmlzayBmb3IgdGhl IGNvbW1vbiBjYXNlLg0KDQpJ4oCZbSB3b3JraW5nIG9uIGEgcGF0Y2ggYWxvbmcgdGhlc2UgbGlu ZXM7IGFueSB0aG91Z2h0cz8NCg0KLS0NCkJlc3QgcmVnYXJkcywNCkNoZW5ncGVuZyBZYW4NCg0K