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 1oLTcE-0002FW-Rf for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 18:06:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLTbF-0001gt-Kc for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 18:05:05 +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 1oLTbF-0001gj-3z for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 18:05:05 +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 1oLTbC-0000je-8b for pgsql-hackers@postgresql.org; Tue, 09 Aug 2022 18:05:03 +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=ptPqP6UTeZjF1B8Iy5A4XhnAyZael2W6ZcOJK2QdMbc=; b=ZSDt+1FUtDFuh4oQVBsqFYaWFn LpaA9fH4UqmhbLVPqVM3g0Z10n06fqCiAVDzispPmNK9kG0hrK8amtLz7mC/WIDUu9BXQtZr0x+mi X6mY3Blj/ds+nsqr2FiAogTcGqz0WE7So/TMvIwAoQry9WOWbTaivbdX/hr5zahPnCRiPIzV3F1VP tHAGz6NlfbgEjl9PApbS3hPbCeYV7x2zFT11PN1R25M7/OisFLHZGC0GyQJOi0RpUMWdSC9p+3e0Q 2psVjtaE1DC/WJ01muT9g1o/ZzHRU0W51lTjW23cJXzhBRgHfA3Pj1PGlhOlBDMbyXBCA+20v9Eya NtBvqH5g==; 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 1oLTb4-0007yO-KR; Tue, 09 Aug 2022 18:04:56 +0000 Message-ID: <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> Date: Tue, 9 Aug 2022 14:04:48 -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: Andrew Dunstan , Andres Freund , Amit Langote Cc: David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Tom Lane , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov References: <20220721171235.7okm3q5i7jyuwtqw@alvherre.pgsql> <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> From: "Jonathan S. Katz" Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size In-Reply-To: <32d4a1e4-d218-b129-205e-e123ebaef6b8@dunslane.net> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------YYOwwEChfGZ3QmQEmCllpiaP" 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) --------------YYOwwEChfGZ3QmQEmCllpiaP Content-Type: multipart/mixed; boundary="------------H7xi4F6kB78HQwZ9guSSuA40"; protected-headers="v1" From: "Jonathan S. Katz" To: Andrew Dunstan , Andres Freund , Amit Langote Cc: David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Tom Lane , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size References: <20220721171235.7okm3q5i7jyuwtqw@alvherre.pgsql> <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> In-Reply-To: <32d4a1e4-d218-b129-205e-e123ebaef6b8@dunslane.net> --------------H7xi4F6kB78HQwZ9guSSuA40 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC85LzIyIDExOjAzIEFNLCBBbmRyZXcgRHVuc3RhbiB3cm90ZToNCj4gDQo+IE9uIDIw MjItMDgtMDkgVHUgMDk6NTksIEpvbmF0aGFuIFMuIEthdHogd3JvdGU6DQoNCj4+IFRoZSBS TVQgbWV0IHRvZGF5IHRvIGRpc2N1c3MgdGhlIHN0YXRlIG9mIHRoaXMgb3BlbiBpdGVtIHN1 cnJvdW5kaW5nDQo+PiB0aGUgU1FML0pTT04gZmVhdHVyZSBzZXQuIFdlIGRpc2N1c3NlZCB0 aGUgc3BlY2lmaWMgY29uY2VybnMgcmFpc2VkDQo+PiBhYm91dCB0aGUgY29kZSBhbmQgZGVi YXRlZCBmb3VyIGRpZmZlcmVudCBvcHRpb25zOg0KPj4NCj4+ICDCoCAxLiBEbyBub3RoaW5n IGFuZCBjb250aW51ZSB3aXRoIHRoZSBjb21tdW5pdHkgcHJvY2VzcyBvZiBzdGFiaWxpemlu Zw0KPj4gdGhlIGNvZGUgd2l0aG91dCBzaWduaWZpY2FudCByZWRlc2lnbg0KPj4NCj4+ICDC oCAyLiBSZWNvbW1lbmQgaG9sZGluZyB1cCB0aGUgdjE1IHJlbGVhc2UgdG8gYWxsb3cgZm9y IHRoZSBjb2RlIHRvIGJlDQo+PiByZWRlc2lnbmVkIGFuZCBmaXhlZCAoYXMgYmFzZWQgb24g QW5kcmVzJyBlc3RpbWF0ZXMsIHRoaXMgd291bGQgcHVzaA0KPj4gdGhlIHJlbGVhc2Ugb3V0 IHNldmVyYWwgbW9udGhzKS4NCj4+DQo+PiAgwqAgMy4gUmV2ZXJ0IHRoZSBwcm9ibGVtYXRp YyBwYXJ0cyBvZiB0aGUgY29kZSBidXQgdHJ5IHRvIGluY2x1ZGUgc29tZQ0KPj4gb2YgdGhl IGZlYXR1cmVzIGluIHRoZSB2MTUgcmVsZWFzZSAoZS5nLiBKU09OX1RBQkxFKQ0KPj4NCj4+ ICDCoCA0LiBSZXZlcnQgdGhlIGZlYXR1cmUgc2V0IGFuZCByZWRlc2lnbiBhbmQgdHJ5IHRv IGluY2x1ZGUgZm9yIHYxNg0KPj4NCj4+IEJhc2VkIG9uIHRoZSBjb25jZXJucyByYWlzZWQs IHRoZSBSTVQgaXMgcmVjb21tZW5kaW5nIG9wdGlvbiAjNCwgdG8NCj4+IHJldmVydCB0aGUg U1FML0pTT04gY2hhbmdlcyBmb3IgdjE1LCBhbmQgY29tZSBiYWNrIHdpdGggYSByZWRlc2ln biBmb3INCj4+IHYxNi4NCj4+DQo+PiBJZiBmb2xrcyB0aGluayB0aGVyZSBhcmUgc29tZSBi aXRzIHdlIGNhbiBpbmNsdWRlIGluIHYxNSwgd2UgY2FuDQo+PiBjb25zaWRlciBvcHRpb24g IzMuIChQZXJzb25hbGx5LCBJIHdvdWxkIGxpa2UgdG8gc2VlIGlmIHdlIGNhbiBrZWVwDQo+ PiBKU09OX1RBQkxFLCBidXQgaWYgdGhlcmUgaXMgdG9vIG11Y2ggb3ZlcmxhcCB3aXRoIHRo ZSBwcm9ibGVtYXRpYw0KPj4gcG9ydGlvbnMgb2YgdGhlIGNvZGUgSSBhbSBmaW5lIHdpdGgg d2FpdGluZyBmb3IgdjE2KS4NCj4+DQo+PiBBdCB0aGlzIHN0YWdlIGluIHRoZSByZWxlYXNl IHByb2Nlc3MgY291cGxlZCB3aXRoIHRoZSBjb25jZXJucywgd2UncmUNCj4+IGEgYml0IHdv cnJpZWQgYWJvdXQgaW50cm9kdWNpbmcgY2hhbmdlcyB0aGF0IGFyZSB1bnByZWRpY3RhYmxl IGluDQo+PiB0ZXJtcyBvZiBzdGFiaWxpdHkgYW5kIG1haW50ZW5hbmNlLiBXZSBhbHNvIGRv IG5vdCB3YW50IHRvIGhvbGQgdXAgdGhlDQo+PiByZWxlYXNlIHdoaWxlIHRoaXMgZmVhdHVy ZSBzZXQgaXMgZ29lcyB0aHJvdWdoIGEgcmVkZXNpZ24gd2l0aG91dA0KPj4gYWdyZWVtZW50 IG9uIHdoYXQgc3VjaCBhIGRlc2lnbiB3b3VsZCBsb29rIGxpa2UgYXMgd2VsbCBhcyBhIHRp bWVsaW5lLg0KPj4NCj4+IE5vdGUgdGhhdCB0aGUgYWJvdmUgYXJlIHRoZSBSTVQncyByZWNv bW1lbmRhdGlvbnM7IHdoaWxlIHRoZSBSTVQgY2FuDQo+PiBleHBsaWNpdGx5IGNhbGwgZm9y IGEgcmV2ZXJ0LCB3ZSB3YW50IHRvIGZpcnN0IGd1aWRlIHRoZSBkaXNjdXNzaW9uIG9uDQo+ PiB0aGUgYmVzdCBwYXRoIGZvcndhcmQga25vd2luZyB0aGUgY2hhbGxlbmdlcyBmb3IgaW5j bHVkaW5nIHRoZXNlDQo+PiBmZWF0dXJlcyBpbiB2MTUuDQo+Pg0KPj4NCj4gDQo+IEkgdmVy eSBtdWNoIGRvdWJ0IG9wdGlvbiAzIGlzIGZlYXNpYmxlLiBUaGUgcGFydHMgdGhhdCBhcmUg Y29udHJvdmVyc2lhbA0KPiBnbyBiYWNrIGF0IGxlYXN0IGluIHBhcnQgdG8gdGhlIGZpcnN0 IHBhdGNoZXMgb2YgdGhlIHNlcmllcy4gVHJ5aW5nIHRvDQo+IHNhbHZhZ2UgYW55dGhpbmcg d291bGQgYWxtb3N0IGNlcnRhaW5seSBiZSBtb3JlIGRpc3J1cHRpdmUgdGhhbiB0cnlpbmcN Cj4gdG8gZml4IGl0Lg0KPiANCj4gSSdtIG5vdCBzdXJlIHdoYXQgdGhlIGRhbmdlciBpcyB0 byBzdGFiaWxpdHksIHBlcmZvcm1hbmNlIG9yIGNvcnJlY3RuZXNzDQo+IGluIGFwcGx5aW5n IHRoZSBjaGFuZ2VzIEFtaXQgaGFzIHByb3Bvc2VkIGZvciByZWxlYXNlIDE1LiBCdXQgaWYg dGhhdA0KPiBkYW5nZXIgaXMganVkZ2VkIHRvIGJlIHRvbyBncmVhdCB0aGVuIEkgYWdyZWUg d2Ugc2hvdWxkIHJldmVydC4NCg0KU3BlYWtpbmcgcGVyc29uYWxseSwgSSB3b3VsZCBsaWtl IHRvIHNlZSB3aGF0IHdlIGNvdWxkIGRvIHRvIGluY2x1ZGUgDQpzdXBwb3J0IGZvciB0aGlz IGJhdGNoIG9mIHRoZSBTUUwvSlNPTiBmZWF0dXJlcyBpbiB2MTUuIFdoYXQgaXMgaW5jbHVk ZWQgDQpsb29rcyBsaWtlIGl0IGNsb3NlcyBtb3N0IG9mIHRoZSBnYXAgb24gd2hhdCB3ZSd2 ZSBiZWVuIG1pc3NpbmcgDQpzeW50YWN0aWNhbGx5IHNpbmNlIHRoZSBzdGFuZGFyZCB3YXMg YWRvcHRlZCwgYW5kIHRoZSBKU09OX1RBQkxFIHdvcmsgaXMgDQp2ZXJ5IGNvbnZlbmllbnQg Zm9yIGNvbnZlcnRpbmcgSlNPTiBkYXRhIGludG8gYSByZWxhdGlvbmFsIGZvcm1hdC4gSSAN CmJlbGlldmUgaGF2aW5nIHRoaXMgZmVhdHVyZSBzZXQgaXMgaW1wb3J0YW50IGZvciBtYWlu dGFpbmluZyBzdGFuZGFyZHMgDQpjb21wbGlhbmNlLCBpbnRlcm9wZXJhYmlsaXR5LCB0b29s aW5nIHN1cHBvcnQsIGFuZCBnZW5lcmFsIHVzYWJpbGl0eS4gDQpQbHVzLCBKU09OIHN0aWxs IHNlZW1zIHRvIGJlIHByZXR0eSBwb3B1bGFyIDopDQoNClJlcmVhZGluZyB0aGUgdGhyZWFk IGZvciB0aGUgdW1wdGVlbnRoIHRpbWUsIEkgaGF2ZSBzZWVuIEFtaXQgd29ya2luZyANCnRo cm91Z2ggQW5kcmVzJyBjb25jZXJucy4gRnJvbSBteSByZWFkLCB0aGUgb25lcyB0aGF0IHNl ZW0gcHJlc3NpbmcgYXJlOg0KDQoqIExhY2sgb2YgZGVzaWduIGRvY3VtZW50YXRpb24sIHdo aWNoIG1heSBiZSBsZWFkaW5nIHRvIHNvbWUgb2YgdGhlIA0KZ2VuZXJhbCBkZXNpZ24gY29u Y2VybnMNCiogVGhlIHVzZSBvZiBzdWJzdHJhbnNhY3Rpb25zIHdpdGhpbiB0aGUgZXhlY3V0 b3IsIHRob3VnaCBkb2NzIA0KZXhwbGFpbmluZyB0aGUgZGVjaXNpb25zIG9uIHRoYXQgY291 bGQgYWxsZXZpYXRlIGl0IChJIHJlYWxpemUgdGhpcyBpcyBhIA0KYmlnIHRvcGljIGFuZCBh bnkgc3VtbWFyeSBJIGdpdmUgd29uJ3QgY2FwdHVyZSB0aGUgZnVsbCBudWFuY2UpDQoqIERl YmF0ZSBvbiBob3cgdG8gaGFuZGxlIHRoZSB0eXBlIGNvZXJjaW9ucw0KDQooUGxlYXNlIGNv cnJlY3QgbWUgaWYgSSd2ZSBtaXNzZWQgYW55dGhpbmcpLg0KDQpJIGhvcGUgdGhhdCB0aGVz ZSBjYW4gYmUgYWRkcmVzc2VkIHNhdGlzZmFjdG9yaWx5IGluIGEgcmVhc29uYWJsZSAocmVh ZDogDQpub3cgYSBtdWNoIHNob3J0ZXIpIHRpbWVmcmFtZSBzbyB3ZSBjYW4gaW5jbHVkZSB0 aGUgU1FML0pTT04gd29yayBpbiB2MTUuDQoNCldpdGggbXkgUk1UIGhhdCBvbiwgdGhlIGlz c3VlIGlzIHRoYXQgd2UncmUgbm93IGF0IGJldGEgMyBhbmQgd2Ugc3RpbGwgDQpoYXZlIG5v dCBub3QgcmVhY2hlZCBhIHJlc29sdXRpb24gb24gdGhpcyBvcGVuIGl0ZW0uIEV2ZW4gaWYg aXQgd2VyZSANCmNvbW1pdHRlZCB0b21vcnJvdywgd2Ugd291bGQgZGVmaW5pdGVseSBuZWVk IGEgYmV0YSA0LCBhbmQgd2Ugd291bGQgd2FudCANCnRvIGxldCB0aGUgY29kZSBiYWtlIGEg Yml0IG1vcmUgdG8gZW5zdXJlIHdlIGdldCBhZGVxdWF0ZSB0ZXN0IGNvdmVyYWdlIA0Kb24g aXQuIFRoaXMgd291bGQgbGlrZWx5IHB1dCB0aGUgcmVsZWFzZSBkYXRlIGludG8gT2N0b2Jl ciwgcHJlc3VtaW5nIHdlIA0KaGF2ZSBub3QgZm91bmQgYW55IG90aGVyIGlzc3VlcyB0aGF0 IGNvdWxkIGNhdXNlIGEgcmVsZWFzZSBkZWxheS4NCg0KV2l0aCBteSBhZHZvY2FjeSBoYXQg b24sIHdlJ3JlIGF0IHRoZSBwb2ludCBpbiB0aGUgcmVsZWFzZSBjeWNsZSB3aGVyZSBJIA0K a2ljayBvZmYgdGhlIEdBIHJlbGVhc2UgcHJvY2VzcyAoZS5nLiBhbm5vdW5jZW1lbnQgZHJh ZnRpbmcpLiBOb3QgDQprbm93aW5nIHRoZSBmaW5hbCBzdGF0dXMgb2YgYSBmZWF0dXJlIHRo YXQncyBsaWtlbHkgdG8gYmUgaGlnaGxpZ2h0ZWQgDQptYWtlcyBpdCBkaWZmaWN1bHQgdG8g d3JpdGUgc2FpZCByZWxlYXNlIGFzIHdlbGwgYXMga2ljayBvZmYgdGhlIG90aGVyIA0KbWFj aGluZXJ5IChlLmcuIHRyYW5zbGF0aW9ucykuIElmIHRoZXJlIGlzIGF0IGxlYXN0IGEgZGVj aXNpb24gb24gbmV4dCANCnN0ZXBzLCBJIGNhbiBhZGp1c3QgdGhlIEdBIHJlbGVhc2UgcHJv Y2VzcyB0aW1lbGluZS4NCg0KPiBJIHNob3VsZCBhZGQgdGhhdCBJJ20gdmVyeSBncmF0ZWZ1 bCB0byBBbWl0IGZvciBoaXMgd29yaywgYW5kIEknbSBzdXJlDQo+IGl0IGlzbid0IHdhc3Rl ZCBlZmZvcnQsIHdoYXRldmVyIHRoZSBkZWNpc2lvbi4NCg0KKzEuIFdoaWxlIEkndmUgYmVl biBxdWlldCBvbiB0aGlzIHRocmVhZCB0byBkYXRlLCBJIGhhdmUgZGVmaW5pdGVseSBzZWVu IA0KQW1pdCB3b3JraW5nIGhhcmQgb24gYWRkcmVzc2luZyB0aGUgY29uY2VybnMuDQoNClRo YW5rcywNCg0KSm9uYXRoYW4NCg== --------------H7xi4F6kB78HQwZ9guSSuA40-- --------------YYOwwEChfGZ3QmQEmCllpiaP 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/x8QSccp8cZScFAmLyocAFAwAAAAAACgkQ8QSccp8cZSeG Wg//fVDyVMBNqwNXCeX9p5NC5kXP4hED1FIPyyPIu6REn9Z9L0PfGnVT0ubgTZY7HNiivqZlCLg3 Y+zN7+3GT+iMp0+A9urZm3bRFfU119r+TzP6H4kgNtiF/fOvgYyY8lMg2XBHqMcfvtd93Lp2I4Sl utD85sMcW+iU+rgfk81aOOvMZY8d390aeG6HlfL/pRYb8tP5NILy2y6iLymupgCafa7Urduh6PxE fffYXfTi915LkpMwimZmy5CShga942FKCRxoVkf7YbWdtEZ5OClrxKqMf4z5xYbqkYsq5f89sW9/ xEaxl7dz0umm0kEQTQzKpoi4qIlR4VEgCh+XaET7DgfRVZhOtz+4s1HDPqgHiWF9CByvi4w1LuRH C4Svoy9gQ6o//3ClEocYnhavWafaObTRTRScdyBfhRhnaM7FUZRNtYtNNaq45HGQmYdznQnvUZB5 zyferjBA3F3t2Z254f+ODsWd47z+araQdpCfIzu5GysxAxzAA/rElo6u+B5b2wN7vN4FyqDKysCK UM6evd1mQs7uvbh3PSexZ+myihh90c7vB45VLfcCGA1PCR9vxsJOVAWkR2Pk0GUTi1RtCEgZD58K r2v031G74L2z0F+OWa5ZeoxFZE/G8ocuRErzo7nE1GSj7d54HUY+qq8Aua9b9JgWbdnRfv7szIU/ Y3E= =VWp0 -----END PGP SIGNATURE----- --------------YYOwwEChfGZ3QmQEmCllpiaP--