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 1oLVPS-0007J7-Dv for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 20:01:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLVOT-0005Ba-7b for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 20:00:01 +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 1oLVOS-000575-Q5 for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 20:00:00 +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 1oLVOL-0001bd-KQ for pgsql-hackers@postgresql.org; Tue, 09 Aug 2022 19:59:59 +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=UOph5acV7CgjNbbhJ7keR1u5eh3QPRs3dWDUNRfn7xA=; b=QHj/Ppwu/wvX5fJwjIpta6NgV4 Nrc1hB066nb1NBm4qnS0Fdc1SuRs0qp1oqG5hElFlUuo51fFgwX52C7tbZHwGFtvfkUXaIyZQ9gDa iTUILhitMos+B6NHTAb5g5T/krfpamwfpZuhRNTh41vNZboEabwWrgumC20hblRsJfEm43KanGWca FMfbCIsAZjeGZ/ft4S9wMtDIZRw3xi3vLVRbGGbND6C9dN95+wL5CGWM+sk7eG3GD+v4dsYVcfuyF augmWHCIt0eTDbgOuikTuZ8dcAywQS3KfM3PtXsQ5228/TzXrvaoNvks3xE0SJG/XuGhVerE7FVvO kD5wvMhw==; 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 1oLVOF-0001Gu-63; Tue, 09 Aug 2022 19:59:49 +0000 Message-ID: <5010c184-088d-f98b-18ea-40ee63be6b04@postgresql.org> Date: Tue, 9 Aug 2022 15:59:44 -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: Andres Freund Cc: Andrew Dunstan , Amit Langote , 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: <20220809185725.t477tp54v3qv4uyi@awork3.anarazel.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------vRhEWF73GAWXRUHm57XBvPAX" 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) --------------vRhEWF73GAWXRUHm57XBvPAX Content-Type: multipart/mixed; boundary="------------1ZqXEo7d743nfMTYXOOxaxaj"; protected-headers="v1" From: "Jonathan S. Katz" To: Andres Freund Cc: Andrew Dunstan , Amit Langote , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Tom Lane , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Message-ID: <5010c184-088d-f98b-18ea-40ee63be6b04@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: <20220809185725.t477tp54v3qv4uyi@awork3.anarazel.de> --------------1ZqXEo7d743nfMTYXOOxaxaj Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC85LzIyIDI6NTcgUE0sIEFuZHJlcyBGcmV1bmQgd3JvdGU6DQo+IEhpLA0KPiANCj4g T24gMjAyMi0wOC0wOSAxNDowNDo0OCAtMDQwMCwgSm9uYXRoYW4gUy4gS2F0eiB3cm90ZToN Cg0KPj4+PiAgIMKgIDIuIFJlY29tbWVuZCBob2xkaW5nIHVwIHRoZSB2MTUgcmVsZWFzZSB0 byBhbGxvdyBmb3IgdGhlIGNvZGUgdG8gYmUNCj4+Pj4gcmVkZXNpZ25lZCBhbmQgZml4ZWQg KGFzIGJhc2VkIG9uIEFuZHJlcycgZXN0aW1hdGVzLCB0aGlzIHdvdWxkIHB1c2gNCj4+Pj4g dGhlIHJlbGVhc2Ugb3V0IHNldmVyYWwgbW9udGhzKS4NCj4gDQo+IE9idmlvdXNseSB0aGF0 J3MgYSBxdWVzdGlvbiBvZiB0aGUgcmVzb3VyY2VzIGJyb3VnaHQgdG8gYmVhci4NCj4gDQo+ ICBGcm9tIG15IGFuZ2xlOiBJJ3ZlIG9idmlvdXNseSBzb21lIG9mIG15IG93biB3b3JrIHRv IHRha2UgY2FyZSBvZiBhcyB3ZWxsLCBidXQNCj4gaXQncyBhbHNvIGp1c3QgaGFyZCB0byBp bXByb3ZlIHNvbWV0aGluZyB0aGF0IGluY2x1ZGVzIGEgbG90IG9mIHVuZG9jdW1lbnRlZA0K PiBkZXNpZ24gZGVjaXNpb25zLg0KDQoqbm9kKg0KDQo+Pj4+ICAgwqAgNC4gUmV2ZXJ0IHRo ZSBmZWF0dXJlIHNldCBhbmQgcmVkZXNpZ24gYW5kIHRyeSB0byBpbmNsdWRlIGZvciB2MTYN Cg0KPiBVbmxlc3Mgd2UgZGVjaWRlIG9uIDQgaW1tZWRpYXRlbHksIEkgdGhpbmsgaXQgbWln aHQgYmUgd29ydGggc3RhcnRpbmcgYQ0KPiBzZXBhcmF0ZSB0aHJlYWQgdG8gZ2V0IG1vcmUg YXR0ZW50aW9uLiBUaGUgc3ViamVjdCBkb2Vzbid0IG5lY2Vzc2FyaWx5IGhhdmUNCj4gZXZl cnlvbmUgZm9sbG93IGFsb25nLg0KDQoqbm9kKiBJJ2xsIGRvIHRoaXMgc2hvcnRseS4NCg0K DQo+PiBSZXJlYWRpbmcgdGhlIHRocmVhZCBmb3IgdGhlIHVtcHRlZW50aCB0aW1lLCBJIGhh dmUgc2VlbiBBbWl0IHdvcmtpbmcNCj4+IHRocm91Z2ggQW5kcmVzJyBjb25jZXJucy4gRnJv bSBteSByZWFkLCB0aGUgb25lcyB0aGF0IHNlZW0gcHJlc3NpbmcgYXJlOg0KPj4NCj4+ICog TGFjayBvZiBkZXNpZ24gZG9jdW1lbnRhdGlvbiwgd2hpY2ggbWF5IGJlIGxlYWRpbmcgdG8g c29tZSBvZiB0aGUgZ2VuZXJhbA0KPj4gZGVzaWduIGNvbmNlcm5zDQo+IA0KPj4gKiBUaGUg dXNlIG9mIHN1YnN0cmFuc2FjdGlvbnMgd2l0aGluIHRoZSBleGVjdXRvciwgdGhvdWdoIGRv Y3MgZXhwbGFpbmluZw0KPj4gdGhlIGRlY2lzaW9ucyBvbiB0aGF0IGNvdWxkIGFsbGV2aWF0 ZSBpdCAoSSByZWFsaXplIHRoaXMgaXMgYSBiaWcgdG9waWMgYW5kDQo+PiBhbnkgc3VtbWFy eSBJIGdpdmUgd29uJ3QgY2FwdHVyZSB0aGUgZnVsbCBudWFuY2UpDQo+IA0KPiBJIGRvbid0 IHRoaW5rIHN1YnRyYW5zYWN0aW9ucyBwZXItc2UgYXJlIGEgZnVuZGFtZW50YWwgcHJvYmxl bS4gSSB0aGluayB0aGUNCj4gZXJyb3IgaGFuZGxpbmcgaW1wbGVtZW50YXRpb24gaXMgcmlk aWN1bG91c2x5IGNvbXBsaWNhdGVkLCBhbmQgd2hpbGUgSSBzdGFydGVkDQo+IHRvIGhhY2sg b24gaW1wcm92aW5nIGl0LCBJIHN0b3BwZWQgd2hlbiBJIHJlYWxseSBjb3VsZG4ndCB1bmRl cnN0YW5kIHdoYXQNCj4gZXJyb3JzIGl0IGFjdHVhbGx5IG5lZWRzIHRvIGhhbmRsZSB3aGVu IGFuZCB3aHkuDQoNCkFoLCB0aGFua3MgZm9yIHRoZSBjbGFyaWZpY2F0aW9uLiBUaGF0IG1h a2VzIHNlbnNlLg0KDQo+PiAqIERlYmF0ZSBvbiBob3cgdG8gaGFuZGxlIHRoZSB0eXBlIGNv ZXJjaW9ucw0KPiANCj4gVGhhdCdzIHBhcnRpYWxseSByZWxhdGVkIHRvIHRoZSBlcnJvciBo YW5kbGluZyBpc3N1ZSBhYm92ZS4NCj4gDQo+IE9uZSB3YXkgdGhpcyBjb2RlIGNvdWxkIGJl IGRyYXN0aWNhbGx5IHNpbXBsaWZpZWQgaXMgdG8gZm9yY2UgYWxsDQo+IHR5cGUtY29lcmNp b25zIHRvIGdvIHRocm91Z2ggdGhlICJpbyBjb2VyY2lvbiIgcGF0aCwgd2hpY2ggY291bGQg YmUNCj4gaW1wbGVtZW50ZWQgYXMgYSBzaW5nbGUgZXhlY3V0aW9uIHN0ZXAgKHdoaWNoIHRo dXMgY291bGQgdHJpdmlhbGx5DQo+IHN0YXJ0L2ZpbmlzaCBhIHN1YnRyYW5zYWN0aW9uKSBh bmQgd291bGQgcmVtb3ZlIGEgbG90IG9mIHRoZSBjb21wbGljYXRlZCBjb2RlDQo+IGFyb3Vu ZCBjb2VyY2lvbnMuDQoNCklmIHdlIHdlbnQgZG93biB0aGlzIHBhdGgsIHdvdWxkIHRoaXMg bWFrZSB5b3UgZmVlbCBtb3JlIGNvbWZvcnRhYmxlIA0Kd2l0aCBpbmNsdWRpbmcgdGhpcyB3 b3JrIGluIHRoZSB2MTUgcmVsZWFzZT8NCg0KVGhhbmtzLA0KDQpKb25hdGhhbg0K --------------1ZqXEo7d743nfMTYXOOxaxaj-- --------------vRhEWF73GAWXRUHm57XBvPAX 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/x8QSccp8cZScFAmLyvLAFAwAAAAAACgkQ8QSccp8cZSf5 Dw/8C6G9CEY2jyt3jXurs9VgdSfZ4HDoyuGTeEr1IffE88pYYuiyn0CCGVdmqIZu/piuPxP0bg9B LKF9au+cQXOib1MDFUYs9GDxcDH3fghyRwxEzm5ShcTkfY96/JtiQH/UeQvJMH05OCOvst8TeGxA BFZ9xJapCDjo3yBHNcn3GwfJ9H2r9ECbQYT1dx+5Fm9zWBnuF8qZEMuvP7XYBMqya4zHReMpUv3b yCdIO3GD8HS1zuTjTdw/TPbv3vx+wqOFUw2MbO8yTnvswa9hXGnRi550GJ30gfCcenqy2SbbdPJH UddnVFzsbKHYKKAXHVgTH56j56B+6WA3RGlOxWr9yNVTEWb59vySXSl1CxjkXqD8Tx2/xaUyO++c EWBgbOaG/bONZh4rwHWage9LrYWJMYFw2IX9i2lYxTwRnTgpPVisj8KgLjFjwT3KvvCxBoimISTp n2VnZqvTYOIsuXjX7o0MRcv+XyLuT/dtsVW7NgLm0yrOnhncPEYZQbofg16r0wHkD0VuS5QisvaU wv0kcXP9xPSFbQXAGZreJl7j/edVdWJ7R1Vn6uXx7V4PUjU0CLTx0pzo6qUpiaBB7eY4D3YG4Pe3 KQ6OOGVk6e469PNFQUL67zP77YdzVxproDUK/b5hbLm6RMb0JaNfKUFF5NmdIOrfVolEqyzZX+Uz kE4= =EfS4 -----END PGP SIGNATURE----- --------------vRhEWF73GAWXRUHm57XBvPAX--