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 1oLPmG-0001mX-Tu for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 14:00:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLPmE-0005Ag-Ih for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 14:00:10 +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 1oLPmD-0005AK-U2 for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 14:00:10 +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 1oLPmA-0004JN-60 for pgsql-hackers@postgresql.org; Tue, 09 Aug 2022 14:00:08 +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=2e1TzWCzia7KG26/6y3XzUFk0aAy4r/rn6ToI2mT5jc=; b=uXNBvVKFWwdW2YEy1x9usbJEAd JoYp1vTEN9amEYO7no1ZselU91HwU7QmB5QkjNiHuLA7PkuH8pBRo6BqLzqJhwc3FdmZD+EHpYY3k dkg3qBRC8Kg+qH9jyJxnMN9AAG7kk3UwkUCFxi4qulORiYq5k3NUzsoAwYH9RvzDGYQoGRwszomji YZfRnMJ4N2ToH6IytRh2M9+u/2gRm/4MvrjT7fjT31JLWJbPI5ucnCeTtjjpngnbCrPiCmH+UCxVm DK1tw8xNLt27U5V0ren4lUabQpptV7psG6K1cREFWhpJZJ+pQWwn/FEjo8XT3tMgszhjH33ehlLFt kv2S4Hqw==; 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 1oLPm0-000279-Vs; Tue, 09 Aug 2022 13:59:59 +0000 Message-ID: <787cef45-15de-8f1d-ed58-a1c1435bfc0e@postgresql.org> Date: Tue, 9 Aug 2022 09:59:51 -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 , Amit Langote Cc: David Rowley , Alvaro Herrera , Andrew Dunstan , 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> From: "Jonathan S. Katz" Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size In-Reply-To: <20220805203656.mdgmajvsahi5srcy@awork3.anarazel.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------1ibi7q5SwSgbkgHPZ1XqqpQ6" 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) --------------1ibi7q5SwSgbkgHPZ1XqqpQ6 Content-Type: multipart/mixed; boundary="------------WLtLc6yZVw3nmr2z0wLGBuan"; protected-headers="v1" From: "Jonathan S. Katz" To: Andres Freund , Amit Langote Cc: David Rowley , Alvaro Herrera , Andrew Dunstan , Michael Paquier , John Naylor , Tom Lane , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: <787cef45-15de-8f1d-ed58-a1c1435bfc0e@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> In-Reply-To: <20220805203656.mdgmajvsahi5srcy@awork3.anarazel.de> --------------WLtLc6yZVw3nmr2z0wLGBuan Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC81LzIyIDQ6MzYgUE0sIEFuZHJlcyBGcmV1bmQgd3JvdGU6DQo+IEhpLA0KPiANCj4g SSB0cmllZCB0byBsb29rIGludG8gc29tZSBvZiB0aGUgcXVlc3Rpb25zIGZyb20gQW1pdCwg YnV0IEkgaGF2ZSBlLmcuIG5vIGlkZWENCj4gd2hhdCBleGFjdGx5IHRoZSB1c2Ugb2Ygc3Vi dHJhbnNhY3Rpb25zIHRyaWVzIHRvIGFjaGlldmUgLSBhZmFpY3MgMWEzNmJjOWRiYTgNCj4g aXMgdGhlIGZpcnN0IHBhdGNoIHRvIGludHJvZHVjZSBuZWVkaW5nIHRvIGV2YWx1YXRlIHBh cnRzIGV4cHJlc3Npb25zIGluIGENCj4gc3VidHJhbnNhY3Rpb24gLSBidXQgdGhlcmUncyBu b3QgYSBzaW5nbGUgY29tbWVudCBleHBsYWluaW5nIHdoeS4NCj4gDQo+IEl0J3MgcmVhbGx5 IGhhcmQgdG8gdW5kZXJzdGFuZCB0aGUgbmV3IGpzb24gY29kZS4gSXQncyBhIHN1YnN0YW50 aWFsIGFtb3VudCBvZg0KPiBuZXcgaW5mcmFzdHJ1Y3R1cmUsIHdpdGhvdXQgYW55IGRlc2ln biBkb2N1bWVudGF0aW9uIHRoYXQgSSBjYW4gZmluZC4gQW5kIGl0J3MNCj4gbm90IGxpa2Ug aXQncyBqdXN0IGNvZGUgdGhhdCdzIGVxdWl2YWxlbnQgdG8gbmVhcmJ5IHN0dWZmLiBUbyBt ZSB0aGlzIGZhbGxzDQo+IHdheSBiZWxvdyBvdXIgc3RhbmRhcmRzIGFuZCBJIHRoaW5rIGl0 J3MgKm1vbnRocyogb2Ygd29yayB0byBmaXguDQo+IA0KPiBFdmVuIGp1c3QgdGhlIGV4cHJl c2lvbiBldmFsdWF0aW9uIGNvZGU6IEV2YWxKc29uUGF0aFZhcigpLA0KPiBFeGVjRXZhbEpz b25Db25zdHJ1Y3RvcigpLCBFeGVjRXZhbEpzb25FeHByKCksIEV4ZWNFdmFsSnNvbigpLiBU aGVyZSdzIG9uZQ0KPiBsYXllciBvZiBzdWJ0cmFuc2FjdGlvbnMgaW4gb25lIG9mIHRoZSBw YXRocyBpbiBFeGVjRXZhbEpzb25FeHByKCksIGFub3RoZXIgaW4NCj4gRXhlY0V2YWxKc29u KCkuIFNvbWUgcGF0aHMgb2YgRXhlY0V2YWxKc29uRXhwcigpIGdvIHRocm91Z2ggc3VidHJh bnNhY3Rpb25zLA0KPiBvdGhlcnMgZG9uJ3QuDQo+IA0KPiBJdCdzIG9uZSB0aGluZyBmb3Ig YSBzbWFsbCBzZXQgb2YgY2hhbmdlcyB0byBiZSBvZiB0aGlzIHF1YWxpdHkuIEJ1dCB0aGlz IGlzDQo+IHByZXR0eSBsYXJnZSAtIGEgcXVpY2sgc3VtbWluZyBvZiBkaWZmc3RhdCBlbmRz IHVwIHdpdGggYWJvdXQgMTdrIGxpbmVzIGFkZGVkLA0KPiBvZiB3aGljaCB+Mi41ayBhcmUg ZG9jcywgfjQuOGsgYXJlIHRlc3RzLg0KDQpUaGUgUk1UIG1ldCB0b2RheSB0byBkaXNjdXNz IHRoZSBzdGF0ZSBvZiB0aGlzIG9wZW4gaXRlbSBzdXJyb3VuZGluZyB0aGUgDQpTUUwvSlNP TiBmZWF0dXJlIHNldC4gV2UgZGlzY3Vzc2VkIHRoZSBzcGVjaWZpYyBjb25jZXJucyByYWlz ZWQgYWJvdXQgDQp0aGUgY29kZSBhbmQgZGViYXRlZCBmb3VyIGRpZmZlcmVudCBvcHRpb25z Og0KDQogICAxLiBEbyBub3RoaW5nIGFuZCBjb250aW51ZSB3aXRoIHRoZSBjb21tdW5pdHkg cHJvY2VzcyBvZiBzdGFiaWxpemluZyANCnRoZSBjb2RlIHdpdGhvdXQgc2lnbmlmaWNhbnQg cmVkZXNpZ24NCg0KICAgMi4gUmVjb21tZW5kIGhvbGRpbmcgdXAgdGhlIHYxNSByZWxlYXNl IHRvIGFsbG93IGZvciB0aGUgY29kZSB0byBiZSANCnJlZGVzaWduZWQgYW5kIGZpeGVkIChh cyBiYXNlZCBvbiBBbmRyZXMnIGVzdGltYXRlcywgdGhpcyB3b3VsZCBwdXNoIHRoZSANCnJl bGVhc2Ugb3V0IHNldmVyYWwgbW9udGhzKS4NCg0KICAgMy4gUmV2ZXJ0IHRoZSBwcm9ibGVt YXRpYyBwYXJ0cyBvZiB0aGUgY29kZSBidXQgdHJ5IHRvIGluY2x1ZGUgc29tZSANCm9mIHRo ZSBmZWF0dXJlcyBpbiB0aGUgdjE1IHJlbGVhc2UgKGUuZy4gSlNPTl9UQUJMRSkNCg0KICAg NC4gUmV2ZXJ0IHRoZSBmZWF0dXJlIHNldCBhbmQgcmVkZXNpZ24gYW5kIHRyeSB0byBpbmNs dWRlIGZvciB2MTYNCg0KQmFzZWQgb24gdGhlIGNvbmNlcm5zIHJhaXNlZCwgdGhlIFJNVCBp cyByZWNvbW1lbmRpbmcgb3B0aW9uICM0LCB0byANCnJldmVydCB0aGUgU1FML0pTT04gY2hh bmdlcyBmb3IgdjE1LCBhbmQgY29tZSBiYWNrIHdpdGggYSByZWRlc2lnbiBmb3IgdjE2Lg0K DQpJZiBmb2xrcyB0aGluayB0aGVyZSBhcmUgc29tZSBiaXRzIHdlIGNhbiBpbmNsdWRlIGlu IHYxNSwgd2UgY2FuIA0KY29uc2lkZXIgb3B0aW9uICMzLiAoUGVyc29uYWxseSwgSSB3b3Vs ZCBsaWtlIHRvIHNlZSBpZiB3ZSBjYW4ga2VlcCANCkpTT05fVEFCTEUsIGJ1dCBpZiB0aGVy ZSBpcyB0b28gbXVjaCBvdmVybGFwIHdpdGggdGhlIHByb2JsZW1hdGljIA0KcG9ydGlvbnMg b2YgdGhlIGNvZGUgSSBhbSBmaW5lIHdpdGggd2FpdGluZyBmb3IgdjE2KS4NCg0KQXQgdGhp cyBzdGFnZSBpbiB0aGUgcmVsZWFzZSBwcm9jZXNzIGNvdXBsZWQgd2l0aCB0aGUgY29uY2Vy bnMsIHdlJ3JlIGEgDQpiaXQgd29ycmllZCBhYm91dCBpbnRyb2R1Y2luZyBjaGFuZ2VzIHRo YXQgYXJlIHVucHJlZGljdGFibGUgaW4gdGVybXMgb2YgDQpzdGFiaWxpdHkgYW5kIG1haW50 ZW5hbmNlLiBXZSBhbHNvIGRvIG5vdCB3YW50IHRvIGhvbGQgdXAgdGhlIHJlbGVhc2UgDQp3 aGlsZSB0aGlzIGZlYXR1cmUgc2V0IGlzIGdvZXMgdGhyb3VnaCBhIHJlZGVzaWduIHdpdGhv dXQgYWdyZWVtZW50IG9uIA0Kd2hhdCBzdWNoIGEgZGVzaWduIHdvdWxkIGxvb2sgbGlrZSBh cyB3ZWxsIGFzIGEgdGltZWxpbmUuDQoNCk5vdGUgdGhhdCB0aGUgYWJvdmUgYXJlIHRoZSBS TVQncyByZWNvbW1lbmRhdGlvbnM7IHdoaWxlIHRoZSBSTVQgY2FuIA0KZXhwbGljaXRseSBj YWxsIGZvciBhIHJldmVydCwgd2Ugd2FudCB0byBmaXJzdCBndWlkZSB0aGUgZGlzY3Vzc2lv biBvbiANCnRoZSBiZXN0IHBhdGggZm9yd2FyZCBrbm93aW5nIHRoZSBjaGFsbGVuZ2VzIGZv ciBpbmNsdWRpbmcgdGhlc2UgDQpmZWF0dXJlcyBpbiB2MTUuDQoNClRoYW5rcywNCg0KSm9u YXRoYW4NCg== --------------WLtLc6yZVw3nmr2z0wLGBuan-- --------------1ibi7q5SwSgbkgHPZ1XqqpQ6 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/x8QSccp8cZScFAmLyaFcFAwAAAAAACgkQ8QSccp8cZScW QhAAh0GzfYK7Jk/mkTup1M120KKHBJPb6RUlwzyepMIR6D68RVpZDK+eytfwiAgw/qv9DDINxQ8h fSR2aAkBYRTcIxNUMeMXqjbwPxRRTYsiqRQBnls+tKRuhAczVpL591fsfmMBuyFxLiiwlB998g7k 2Jdl0Awy17stsnWXHj/fXg3Zriiw4xrXuGGziIAeYSq4ZZnNFknRcnu0e7f7wpm+OPMJEMy401II to2zUJYlLwzwnMbuR8/QDwVYOicx6xA8S6F8Y5HP01xMAgGjdikmQGHuew94Tyoye1HE044gF+dY UCl+DrSw48YGp1zlL+bYPo58J6gNbfSJt4xRS0keU4mcTjmQlDDwkfRLz9Hn1AxcMndS5e83nyJa PMBoSVw2pS22mqGVpKJZuDNAgreFyPCZ7Fr0UjZoaBBdg1l3w4Oy3qmwMXiRx7qkWssmGxzbsY5l bRRPQf+ge8ThdvBKkcLGtG5R7JGez+NiDmgVNuzvxKujKv6v5hsbjjhrpG5G0148aGeCjEMyLu0R N5H3FCeAGF9v59PVzVB7mUNngdhNuSWNtUpWjgTOtNYG7kIyEkkmmHW3sCr5dMW7vBP46WTB5wGr ZPI1qglsAMv4WjOch0aTlTSZK6w4l+oUptpkr5LEhe5cIwgEM1TrfnKHD0anpITY5oIIRVXBtAx6 9II= =4IbQ -----END PGP SIGNATURE----- --------------1ibi7q5SwSgbkgHPZ1XqqpQ6--