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 1oMBfj-0008Lv-1a for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Aug 2022 17:08:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oMBfh-0001Gl-VI for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Aug 2022 17:08:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMBfh-0001FT-La for pgsql-hackers@lists.postgresql.org; Thu, 11 Aug 2022 17:08:37 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMBff-0006QN-S5 for pgsql-hackers@postgresql.org; Thu, 11 Aug 2022 17:08:37 +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=eEbKqL5cPfGIFFSeco8GT/SUGlFYYB0UHEyHXWNTLhY=; b=Ial7N0aVFacnSsK/fJfkCeVLBh 5GapMVVWZrvfPJPsARb4RMIFEGCKb8kqqZoKkOw1CwPFJ1BvoMBzlBPKzzK8pQxbctzlxxUcnnQOe Xtk9Wz8rxzCPvnufBwCVPDhNldixHBgoQqeqQ6EfqNws7SHz5aoy2mqdgMsRC79YcKllR9e13iCdi VLkCbTkSswNiAmi+HBjpxtD1Kk+8ANQnfJ4OTRmlaWVk2++SlX5f1kXUm/DJBbDFVg2tSgWz/sPiD +Vy+OtuIV8ON7N0ebamiIRwpBQAz7Y6ZjLcllJ9ziZ/HQNKhbOMS1nubMkQJGHEPMj8MpULRkvKuN mG9wlTmA==; 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 1oMBfa-0000fp-N2; Thu, 11 Aug 2022 17:08:32 +0000 Message-ID: <25fc391a-1197-cfbf-cf4a-bce4c03e7fbf@postgresql.org> Date: Thu, 11 Aug 2022 13:08:27 -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: Amit Langote , Andres Freund Cc: Andrew Dunstan , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Tom Lane , 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> <20220809185725.t477tp54v3qv4uyi@awork3.anarazel.de> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------soCWNys9tiYkFb3mdFJDwwQ0" 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) --------------soCWNys9tiYkFb3mdFJDwwQ0 Content-Type: multipart/mixed; boundary="------------5s4uWAaeztSV14eKUuK9Osbw"; protected-headers="v1" From: "Jonathan S. Katz" To: Amit Langote , Andres Freund Cc: Andrew Dunstan , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Tom Lane , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: <25fc391a-1197-cfbf-cf4a-bce4c03e7fbf@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> <20220809185725.t477tp54v3qv4uyi@awork3.anarazel.de> In-Reply-To: --------------5s4uWAaeztSV14eKUuK9Osbw Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8xMC8yMiA5OjI3IEFNLCBBbWl0IExhbmdvdGUgd3JvdGU6DQo+IE9uIFdlZCwgQXVn IDEwLCAyMDIyIGF0IDM6NTcgQU0gQW5kcmVzIEZyZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRl PiB3cm90ZToNCj4+IE9uZSB3YXkgdGhpcyBjb2RlIGNvdWxkIGJlIGRyYXN0aWNhbGx5IHNp bXBsaWZpZWQgaXMgdG8gZm9yY2UgYWxsDQo+PiB0eXBlLWNvZXJjaW9ucyB0byBnbyB0aHJv dWdoIHRoZSAiaW8gY29lcmNpb24iIHBhdGgsIHdoaWNoIGNvdWxkIGJlDQo+PiBpbXBsZW1l bnRlZCBhcyBhIHNpbmdsZSBleGVjdXRpb24gc3RlcCAod2hpY2ggdGh1cyBjb3VsZCB0cml2 aWFsbHkNCj4+IHN0YXJ0L2ZpbmlzaCBhIHN1YnRyYW5zYWN0aW9uKSBhbmQgd291bGQgcmVt b3ZlIGEgbG90IG9mIHRoZSBjb21wbGljYXRlZCBjb2RlDQo+PiBhcm91bmQgY29lcmNpb25z Lg0KPiANCj4gQ291bGQgeW91IHBsZWFzZSBjbGFyaWZ5IGhvdyB5b3UgdGhpbmsgd2UgbWln aHQgZG8gdGhlIGlvIGNvZXJjaW9uDQo+IHdyYXBwZWQgd2l0aCBhIHN1YnRyYW5zYWN0aW9u IGFsbCBhcyBhIHNpbmdsZSBleGVjdXRpb24gc3RlcD8gIEkNCj4gd291bGQndmUgdGhvdWdo dCB0aGF0IHdlIGNvdWxkbid0IGRvIHRoZSBzdWItdHJhbnNhY3Rpb24gd2l0aG91dA0KPiBs ZWF2aW5nIEV4ZWNJbnRlcnBFeHByKCkgYW55d2F5LCBzbyBtYXliZSB5b3UgbWVhbnQgdGhl IGlvIGNvZXJjaW9uDQo+IGl0c2VsZiB3YXMgZG9uZSB1c2luZyBzb21lIGNvZGUgb3V0c2lk ZSBFeGVjSW50ZXJwRXhwcigpPw0KPiANCj4gVGhlIGN1cnJlbnQgSnNvbkV4cHIgY29kZSBk b2VzIGl0IGJ5IHJlY3Vyc2l2ZWx5IGNhbGxpbmcNCj4gRXhlY0ludGVycEV4cHIoKSB1c2lu ZyB0aGUgbmVzdGVkIEV4cHJTdGF0ZSBleHByZXNzbHkgZm9yIHRoZQ0KPiBjb2VyY2lvbi4N Cg0KV2l0aCBSTVQgaGF0IG9uLCBBbmRyZXMgZG8geW91IGhhdmUgYW55IHRob3VnaHRzIG9u IHRoaXM/DQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg== --------------5s4uWAaeztSV14eKUuK9Osbw-- --------------soCWNys9tiYkFb3mdFJDwwQ0 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/x8QSccp8cZScFAmL1N4sFAwAAAAAACgkQ8QSccp8cZScE XBAAk8FJ1ttQ1aagZ3LgFDqnsZwObcrzxNCmuuNq+RXRYeIrx5/yMXD2TdPYvKqKohNWW/LxH5K4 fbLzyTA/mvFv1aF3t7sGV/B0ikHpi3ybflia48etto6WvvSN5Ug6WveA7Y4aWXFAMozaygdrR9gB V242rIYvk4tXDyj6BKyIH9xqnee2cB2o0p4axLBIaZYw4y8AbOoReJ6jlSeksuLmFqBdw2G8NJ/Y Zjx8uJaRolVYXtl7quI1e78QpZRAKhnBgIQ7M/H9zF8MtV7rJu6VJoA1ehp3DOduMhg1GStPxZDq 10CY8eGcurzSt0CYA8XsWdV/VJTz6NSsrRjdlmZWqlWGk0XcJ17FbdaBNx5XpPXFv3HGnJeR8++7 VCIFoeIM5ZncPfQqfBWqAnDU57+MvrxEe23o5HbhTdVXjtL/JNxEP6FrhuS6glruxYZiNUz2f6xF 1JGgv6aqpgvadbUDQ2kQ1WYuOTHGvNZ/kOs9FQDWAT18g2v0yPLxLNr/34SiBXgMUUvYJdcGOv9C XkZGWfPqbNUz27BeiCyNsv1+Bla+XfCfZhXkwwCJIWsW6JV+vi0XDTqToXsgoIpPd+bLyNwDlxux Dx1F/AfbD3AbmOnhEBrj8MKou2s8RKdfnRZzPGx1jJ4e/yKarjeRzdfQP+xkxk0OsJkTrmo80TTm HyM= =fJtm -----END PGP SIGNATURE----- --------------soCWNys9tiYkFb3mdFJDwwQ0--