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 1oLVGd-0006mX-AD for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 19:51:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLVFc-00073n-8s for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 19:50:52 +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 1oLVFb-00073e-Vq for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 19:50:51 +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 1oLVFY-0006AA-GJ for pgsql-hackers@postgresql.org; Tue, 09 Aug 2022 19:50:51 +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:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=X7+HaxdaA/25KRm1AAEyV2wny8gxjN7OFEGpXgD1Qmo=; b=k0+rzTyyzcD7dLij9ucT9gFD9E Uc/wifQ/fYHO/30WSQGZoD9qpJtJlXnIwTv3jdHSmKbtkTPc8TWqzAcAeNevpL3JBCJakJDhZA1oC RJuU8jivNHCdYJAbWVv8W9nQRlDxfpGboIam8ZtPFYj3dGlKZXABTgO9I+M/BBfeXs2UTaH5oqUQg PtWqcmB9K2B9L7jfXqbX6Naj8yFnEEXbjR1BSuvI80W+T0GRQcX+DqIsgjTOvC2bctDgSP3catFrc 6rhdBdLqrww235pIi0TvV521As1sRTJ2vmLr4AFeUccMuaIpUNWjwLG91vJ+qdyG6YLOicif4es/N qad2kxmA==; 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 1oLVFR-00019c-2t; Tue, 09 Aug 2022 19:50:44 +0000 Message-ID: Date: Tue, 9 Aug 2022 15:50:36 -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 Content-Language: en-US To: Andres Freund , Tom Lane Cc: Andrew Dunstan , 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" Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size In-Reply-To: <20220809192257.yanxb6cazo2tjkkh@awork3.anarazel.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------W0aOOYBxZuvfpFxuSnlEOqFD" 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) --------------W0aOOYBxZuvfpFxuSnlEOqFD Content-Type: multipart/mixed; boundary="------------hCgdtjHMqA88Rnh0TEuXU0oj"; protected-headers="v1" From: "Jonathan S. Katz" To: Andres Freund , Tom Lane Cc: Andrew Dunstan , Amit Langote , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: 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: <20220809192257.yanxb6cazo2tjkkh@awork3.anarazel.de> --------------hCgdtjHMqA88Rnh0TEuXU0oj Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC85LzIyIDM6MjIgUE0sIEFuZHJlcyBGcmV1bmQgd3JvdGU6DQo+IEhpLA0KPiANCj4g T24gMjAyMi0wOC0wOSAxNToxNzo0NCAtMDQwMCwgVG9tIExhbmUgd3JvdGU6DQo+PiBXZSBo YXZlIGRlbGF5ZWQgcmVsZWFzZXMgZm9yICRDT09MX0ZFQVRVUkUgaW4gdGhlIHBhc3QsIGFu ZCBJIHRoaW5rDQo+PiBvdXIgYmF0dGluZyBhdmVyYWdlIG9uIHRoYXQgaXMgc3RpbGwgLjAw MDogbm90IG9uY2UgaGFzIGl0IHdvcmtlZCBvdXQNCj4+IHdlbGwuDQo+IA0KPiBJIHRoaW5r IGl0IHNlbWkgd29ya2VkIHdoZW4ganNvbmIgKD8pIGZpcnN0IHdlbnQgaW4gLSBpdCB0b29r IGEgd2hpbGUgYW5kIGENCj4gbG90IG9mIGVmZm9ydCBmcm9tIGEgbG90IG9mIHBlb3BsZSwg YnV0IGluIHRoZSBlbmQgd2UgbWFkZSBpdCB3b3JrLCBhbmQgaXQgd2FzDQo+IGEgc3VjY2Vz cyBmcm9tIG91ciB1c2VyJ3MgcGVyc3BlY3RpdmVzLCBJIHRoaW5rLiANCg0KWWVhaCwgdGhp cyB3YXMgdGhlIGV4YW1wbGUgSSB3YXMgdGhpbmtpbmcgb2YuIFRvIGNvbnRpbnVlIHdpdGgg dGhlIA0KYmFzZWJhbGwgYW5hbG9neSwgaXQgd2FzIGEgaG9tZS1ydW4gZnJvbSBhIFBSIHBl cnNwZWN0aXZlLCBhbmQgSSBjYW4gc2F5IA0KYXMgYSBwb3dlciB1c2VyIGF0IHRoZSB0aW1l LCB0aGUgOS40IEpTT05CIHJlcHJlc2VudGF0aW9uIHdvcmtlZCB3ZWxsIA0KZm9yIG15IHVz ZSBjYXNlLiBDZXJ0YWlubHkgbmV3ZXIgZnVuY3Rpb25hbGl0eSBoYXMgbWFkZSBKU09OIGVh c2llciB0byANCndvcmsgd2l0aCBpbiBQRy4NCg0KKEkgY2FuJ3QgcmVtZW1iZXIgd2hhdCB0 aGUgOS41IGhvbGQgdXAgd2FzKS4NCg0KVGhlIGNhc2VzIHdoZXJlIHdlIGVpdGhlciBkZWxh eWVkL3B1bnRlZCBvbiAkQ09PTF9GRUFUVVJFIHRoYXQgY2F1c2UgbWUgDQpjb25jZXJuIGFy ZSB0aGUgb25lcyB3aGVyZSB3ZSBzYXkgIk9LLCB3ZWxsIGZpeCB0aGlzIGluIHRoZSBuZXh0 IA0KcmVsZWFzZSIgYW5kIHdlIGFyZSB0aGVuIHdhaXRpbmcsIDIsIDMsIDQgcmVsZWFzZXMg Zm9yIHRoZSB3b3JrIHRvIGJlIA0KY29tcGxldGVkLiBBbmQgdG8gYmUgY2xlYXIsIEknbSB0 aGlua2luZyBvZiB0aGlzIGFzICJrbm93biBpc3N1ZXMiIHZzLiANCiJpdGVyYXRpbmcgdG93 YXJkcyB0aGUgd2hvbGUgc29sdXRpb24iLg0KDQo+IE9UT0gsIGl0J3Mgbm90IGEgZ3JlYXQg c2lnbiAgdGhpcyBpcyBhcm91bmQganNvbiBhZ2Fpbi4uLg0KDQpZZWFoLCBJIHdhcyB0aGlu a2luZyBhYm91dCB0aGF0IHRvby4NCg0KUGVyIEFuZHJlcyBjb21tZW50IHVwdGhyZWFkLCBs ZXQncyBvcGVuIGEgbmV3IHRocmVhZCB0byBkaXNjdXNzIHRoZSANClNRTC9KU09OICsgdjE1 IHRvcGljIHRvIGltcHJvdmUgdmlzaWJpbGl0eSBhbmQgZ2V0IG1vcmUgZmVlZGJhY2suIEkg Y2FuIA0KZG8gdGhhdCBzaG9ydGx5Lg0KDQpXZSBjYW4gY29udGludWUgd2l0aCB0aGUgdGVj aG5pY2FsIGRpc2N1c3Npb24gaW4gaGVyZS4NCg0KSm9uYXRoYW4NCg== --------------hCgdtjHMqA88Rnh0TEuXU0oj-- --------------W0aOOYBxZuvfpFxuSnlEOqFD 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/x8QSccp8cZScFAmLyuowFAwAAAAAACgkQ8QSccp8cZSce tRAAllWyKET4faZ1aT3fPAem/njvZqYhBLbWQoluGKCmb3IFlT+l4G0S1DBvVH5Le6vGgO1iqSwA cVhbnoadd/cmlKrTKZc3jrOJNwhMajR0wmoHnaItcuWY4eZ4kfnRB8I9meB+P+4BKv4NAGEUCbZG IOsUrpTTSYboG2+K2GoWjG7V+7jgfveMUx6o96ci43delQrm7On5gtLM17SJdAIvlczW2H79XEyR +cfiA6tD7CXmNur2mXxlluYe81CaZy6HJ5NToD5e72LZmlItAVWugN9i2jSU1FZ1UuyneM9JziIX J+s8zB8D5VBbyHShfLhxssU0Ox+eD/6gzTDoGRyERTWFJx+qmX37kH7FiE07Fe2LogayVib0Its7 7WPQkCDJw87d/TVROS3gEMn3n3SILOfF0mcEBkhvKmxzZtkBQVJpPUpLCL2mSaAqqYQISLBMX+vT ONm/qoxZvqEL/ArnNXCqTiWhqB/NgO+JrOyocpJkE3hb7zbSdpoP1ubXjBEmeM6lu71O+6KMNJmK FSkiz3prEBX2OMM/Nl4THgs+G/oB389ivkpdSiA/AhcSk/KCX2TJ76q6WMRFero11pjDFNAIYubp B3Zm6IFKRwW2DWUHK4AIEOmtaB12tqokePzyZ44eErlR/vcxj6YU+48rJDHRnOv9+o5IwEAWT9YO b0w= =DlZy -----END PGP SIGNATURE----- --------------W0aOOYBxZuvfpFxuSnlEOqFD--