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 1oLVhc-0008Cg-Mk for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 20:19:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLVhb-0001C5-Jd for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 20:19:47 +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 1oLVhb-0001Bw-AO for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 20:19:47 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLVhY-0001kY-4R for pgsql-hackers@postgresql.org; Tue, 09 Aug 2022 20:19:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=QQvSDmgh3idsFrPQ26N/7EVGeIT7Dbib5xI3unUSSW8=; b=cjw83E0Op/AJap1bITmBFU894C CVlAO4moaURqN5S4tokhInRklSIWnHIjUhS2aIgGIpvtcQhgXbsy1GpsVspco6dMmcEZbOdvZ48oq bVQKsFDEi7D7QAU8dqsJ7f9NsJ1cuyU1mZK5KACwEeVrBT6tLXkaTSdWhbAJ0+tQ1sJtBi1t7qCDx l2Zo0U27wi4viZlAyWtSd7ZFJ5iomQNezs58fcVQu5GuSJUoSufreOBKhdSCsyOeAYmGQ/FCf7Pvs str7feGeqZDAwf6zSm9oUlvtyh42GLbgCxKpnMllRcqx+DW9yX4gGZo1oFoQKl6LUQDOKWH05Y/wO EbRv5S7g==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oLVhR-0001eF-NR; Tue, 09 Aug 2022 20:19:39 +0000 Message-ID: <363285e0-7f98-593b-4380-3ef2fe3fb66a@postgresql.org> Date: Tue, 9 Aug 2022 16:19:33 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.12.0 Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Content-Language: en-US To: Andrew Dunstan , Andres Freund , Tom Lane Cc: Amit Langote , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov References: <20220802003947.x2ezq7u7pkmxt6ie@awork3.anarazel.de> <20220802150022.jqomxwum5eazybfv@awork3.anarazel.de> <20220805203656.mdgmajvsahi5srcy@awork3.anarazel.de> <787cef45-15de-8f1d-ed58-a1c1435bfc0e@postgresql.org> <32d4a1e4-d218-b129-205e-e123ebaef6b8@dunslane.net> <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> <35778.1660072664@sss.pgh.pa.us> <20220809192257.yanxb6cazo2tjkkh@awork3.anarazel.de> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------e9jkXzrL0Te0sUMuWAPHWc7B" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------e9jkXzrL0Te0sUMuWAPHWc7B Content-Type: multipart/mixed; boundary="------------yyUYyZhOqHkFaSKkHIDGs0YX"; protected-headers="v1" From: "Jonathan S. Katz" To: Andrew Dunstan , Andres Freund , Tom Lane Cc: Amit Langote , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: <363285e0-7f98-593b-4380-3ef2fe3fb66a@postgresql.org> Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size References: <20220802003947.x2ezq7u7pkmxt6ie@awork3.anarazel.de> <20220802150022.jqomxwum5eazybfv@awork3.anarazel.de> <20220805203656.mdgmajvsahi5srcy@awork3.anarazel.de> <787cef45-15de-8f1d-ed58-a1c1435bfc0e@postgresql.org> <32d4a1e4-d218-b129-205e-e123ebaef6b8@dunslane.net> <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> <35778.1660072664@sss.pgh.pa.us> <20220809192257.yanxb6cazo2tjkkh@awork3.anarazel.de> In-Reply-To: --------------yyUYyZhOqHkFaSKkHIDGs0YX Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC85LzIyIDQ6MTUgUE0sIEFuZHJldyBEdW5zdGFuIHdyb3RlOg0KPiANCj4gT24gMjAy Mi0wOC0wOSBUdSAxNTo1MCwgSm9uYXRoYW4gUy4gS2F0eiB3cm90ZToNCj4+IE9uIDgvOS8y MiAzOjIyIFBNLCBBbmRyZXMgRnJldW5kIHdyb3RlOg0KDQo+Pg0KPj4+IE9UT0gsIGl0J3Mg bm90IGEgZ3JlYXQgc2lnbsKgIHRoaXMgaXMgYXJvdW5kIGpzb24gYWdhaW4uLi4NCj4+DQo+ PiBZZWFoLCBJIHdhcyB0aGlua2luZyBhYm91dCB0aGF0IHRvby4NCj4gDQo+IA0KPiBPdWNo IDotKA0KPiANCj4gSSB0aGluayBhZnRlciAxMCB5ZWFycyBvZiBiZWluZyBpbnZvbHZlZCB3 aXRoIG91ciBKU09OIGZlYXR1cmVzLCBJJ20NCj4gZ29pbmcgdG8gdGFrZSBhIHN1YnN0YW50 aWFsIGJyZWFrIG9uIHRoYXQgZnJvbnQuDQoNCkkgaG9wZSB0aGF0IHdhc24ndCB0YWtlbiBh cyBhIHNsZWlnaHQsIGJ1dCBqdXN0IGFuIG9ic2VydmF0aW9uLiBUaGVyZSANCmFyZSBvdGhl ciBmZWF0dXJlIGFyZWFzIHdoZXJlIEkgY2FuIG1ha2Ugc2ltaWxhciBvYnNlcnZhdGlvbnMu IEFsbCB0aGlzIA0Kd29yayBhcm91bmQgYSBkYXRhYmFzZSBzeXN0ZW0gaXMgY2hhbGxlbmdp bmcgYXMgdGhlcmUgYXJlIG1hbnkgDQpjb25zaWRlcmF0aW9ucyB0aGF0IG5lZWQgdG8gYmUg bWFkZS4NCg0KWW91J3ZlIGRvbmUgYW4gYXdlc29tZSBqb2IgZHJpdmluZyB0aGUgSlNPTiB3 b3JrIGZvcndhcmQgYW5kIGl0IGlzIA0KZ3JlYXRseSBhcHByZWNpYXRlZC4NCg0KVGhhbmtz LA0KDQpKb25hdGhhbg0K --------------yyUYyZhOqHkFaSKkHIDGs0YX-- --------------e9jkXzrL0Te0sUMuWAPHWc7B Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmLywVUFAwAAAAAACgkQ8QSccp8cZSdf HA/7BnbR0xP+Q5Iie4/ovP7NTPKqh9hYRHW3BsnwsPLtr4PtAN3rTe+Kn0S1Svihv0zJM3D+x/HV /VBzwTbNvIAhH7u1cRpa9G/xD5Mpk2SltSHzi5xYtvuWaN7e7TLT+IFXviq57XglVYvY8PNpQMue 0Tu9S13XE4DgUekTAT1WINb8RrKJrUCvEXxBlY6rbSP/mBlRheUKBjUPAWA5+SN9n5pFYquFlPzj R5qWfEK6vzWbWkdAJQGJApPHUEGHXv0AnwOQTvaB5Iu/dnkLriDCoNTFa9ZTjQ2CbmegiEq2CfLn qpMdIDLkDStdM+I3Q3PLv0KkilrQQmJNgxJN0hsB3+dE/aCDO4sUxX9waCokzms5zyQkYxIgW5R+ dpPPSYZc/3CNvIVcQsg0In4T7ToUBRzTZtaLDf+wfXFmimpSl8OmqNSEc9D4ErYbC9P6c9h5Gv6z hdEy4jHEXda13M9WeQdYGIWFCEDB/Gd5hNUBVAz/fmwJiSTbWWEfzYMeEd1oVkPuxCXEO4g4SaX9 xDCuyDd9qiVlbhOiY1H/WDQBTiJaJvln2kD9Gi/EXPURSFxxMvzV/Pu6bj74nsK1ef+VU3KEixm1 bXdKKobENVlSSn6EJlZjtuZmhFTnHHPisUSbpwhJJULfXuRXw62WaEqk2qDp8xwCTjJkbca3ZjOi O9I= =ndj0 -----END PGP SIGNATURE----- --------------e9jkXzrL0Te0sUMuWAPHWc7B--