Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thBcQ-00HQMi-63 for pgsql-bugs@arkaria.postgresql.org; Sun, 09 Feb 2025 18:01:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1thBbQ-00FZZG-Sr for pgsql-bugs@arkaria.postgresql.org; Sun, 09 Feb 2025 18:00:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thBOd-00FU43-H2 for pgsql-bugs@lists.postgresql.org; Sun, 09 Feb 2025 17:47:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1thBOa-004Blv-30 for pgsql-bugs@lists.postgresql.org; Sun, 09 Feb 2025 17:47:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=vx8vhLBXP6+8GCPNnArGd1buUE0MvBXV35oMzC/OMKk=; b=J9WwQdQZMQKraj6J+dsJP8Xz0P c4u8AqVgan5fpvkthbkGq58F5paFEpMBB0PdfH5EVfO1oe9yJG+bBpxKa6tDKOlqHKwEuBKVBAr9/ Y9V7PsqG9SncLLRZNmq5YuYaD+Y8XlK0gqGmIwr0mJLBL4YOonRCLMqp9i/LOf6LSxEJkgaIbISW2 R9D33RKZ7olFTo2pNxylGAmdsRhrr+oKSUAmwfflpj+DdQoYPfyUL/yFaMPr7i8RspkEL85a0Rf46 T0qt75eRNeMNe5frVwe7I9U9DqbrbpAZtqwYHCea2qeSJQ2gEUjaWOhnoTkBHyrl9kxV+qjv5KHJe HprReQdw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thBOa-000q7I-Pf for pgsql-bugs@lists.postgresql.org; Sun, 09 Feb 2025 17:47:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1thBOZ-002f3I-9K for pgsql-bugs@lists.postgresql.org; Sun, 09 Feb 2025 17:47:03 +0000 Content-Type: multipart/mixed; boundary="===============2332314996577310057==" MIME-Version: 1.0 Subject: BUG #18801: JIT recompiles function for each row if custom aggregation function is used To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: foxido@foxido.dev Reply-To: foxido@foxido.dev, pgsql-bugs@lists.postgresql.org Date: Sun, 09 Feb 2025 17:46:55 +0000 Message-ID: <18801-8657563d6f52110b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2332314996577310057== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgwMQpMb2dnZWQgYnk6ICAgICAgICAgIElseWEgR2xhZHlzaGV2CkVt YWlsIGFkZHJlc3M6ICAgICAgZm94aWRvQGZveGlkby5kZXYKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ny4yCk9wZXJhdGluZyBzeXN0ZW06ICAgYXJjaCBsaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoK SGkhIEkndmUgbm90aWNlZCB0aGF0IGZvciBjdXN0b20gYWdncmVnYXRpb24gZnVuY3Rpb24gaml0 IChyZSljb21waWxlcyBzYW1lCmNvZGUgZm9yIGV2ZXJ5IHJvdy4NCg0KQ29uc2lkZXIgdGhpcyBj b2RlIHNhbXBsZToNCmBgYA0KY3JlYXRlIHRhYmxlIHRlc3QoYSBmbG9hdCwgYiBmbG9hdCk7DQpp bnNlcnQgaW50byB0ZXN0IHNlbGVjdCBhLCBhICUgMTAgZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMSwg MTAwMDApIGE7DQoNCmNyZWF0ZSBmdW5jdGlvbiBjdXN0b21fbWF4KGZsb2F0OCwgZmxvYXQ4KSBy ZXR1cm5zIGZsb2F0OCBhcw0KJCQNCiAgc2VsZWN0IGNhc2Ugd2hlbiAkMSA+ICQyIHRoZW4gJDEg ZWxzZSAkMiBlbmQNCiQkDQpsYW5ndWFnZSBzcWw7DQoNCmNyZWF0ZSBhZ2dyZWdhdGUgY3VzdG9t X2FnZ19tYXgoZmxvYXQ4KQ0KKA0KICAgIHNmdW5jID0gY3VzdG9tX21heCwNCiAgICBzdHlwZSA9 IGZsb2F0OCwNCiAgICBpbml0Y29uZCA9IDANCik7DQoNCnNldCBqaXQgPSBvbjsNCnNldCBqaXRf YWJvdmVfY29zdCA9IDA7DQpzZXQgaml0X2R1bXBfYml0Y29kZSA9IG9uOw0KZXhwbGFpbiBhbmFs eXplIHNlbGVjdCBjdXN0b21fYWdnX21heChhKSAgZnJvbQ0KdGVzdDsNCmBgYA0KDQpUaGlzIHF1 ZXJ5IHJ1bnMgfjggc2Vjb25kcyAoWzFdKSBhbmQgZ2VuZXJhdGVzIDEwMDAxIGxsdm0gYnl0ZWNv ZGUgZmlsZXMgaW4KZGF0YSBkaXJlY3RvcnkuIEZvciBjb21wYXJpc29uLCBidWlsdC1pbiBgc2Vs ZWN0IG1heChhKSBmcm9tIHRlc3RgIHJ1bnMKfjUwbXMgYW5kIGdlbmVyYXRlcyAyIGJ5dGVjb2Rl IGZpbGVzLg0KDQpBbmQgYWxsIGJ5dGVjb2RlIGZpbGVzIGFyZSBzYW1lLCB3aXRoIG9ubHkgZGlm ZmVyZW5jZSBiZXR3ZWVuIHRoZW0gaXMKZnVuY3Rpb24gbmFtZXMgWzJdLg0KDQpXaGF0IGkgdGVz dGVkIHNvIGZhcjoNCuKAlCBidWcgZGlzYXBwZWFycyBpZiBzZnVuYyBpbiBhZ2dyZWdhdGUgaXMg YnVpbHQtaW4gKGZvciBleGFtcGxlIGlmCmN1c3RvbV9hZ2cgaXMgWzNdKQ0K4oCUIGJ1ZyBzdGls bCBwcmVzZW50IGlmIGZ1bmN0aW9uIGlzIG1hcmtlZCBhcyBwdXJlIGFzIHBvc3NpYmxlIChwYXJh bGxlbApzYWZlLCBsZWFrcHJvb2YsIGltbXV0YWJsZSwgZXRjKSwgYnV0IGV2ZW4gZm9yIGlucHVy ZSBmdW5jdGlvbnMgaml0IA0Kc2hvdWxkbid0IHJlY29tcGlsZSBmb3IgZWFjaCByb3cNCg0KQWxz byBub3RpY2UgdGhhdCBKSVQgcnVudGltZSBjb3VudGVycyBhcmUgaW5jb3JyZWN0LCBhY3R1YWxs eSB+OTAlIHRpbWUgaXMKc3BlbnQgaW5zaWRlIGxsdm0gKEZQUGFzcyksIGFjY29yZGluZyB0byBw ZXJmLg0KDQpCdWcgaXMgcHJlc2VudCBvbiAxNy4yIGFuZCBtYXN0ZXIgKDk5MjZmODUpDQoNClsx XQ0KYGBgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEFnZ3JlZ2F0ZSAgKGNvc3Q9MjY1 NS4wMC4uMjY1NS4wMSByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTgxNTQuODA1Li44MTU0 LjgwNiByb3dzPTEgbG9vcHM9MSkNCiAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NjkNCiAgIC0+ICBT ZXEgU2NhbiBvbiB0ZXN0ICAoY29zdD0wLjAwLi4xNTUuMDAgcm93cz0xMDAwMCB3aWR0aD04KSAo YWN0dWFsCnRpbWU9MC4wMzMuLjMuMzcxIHJvd3M9MTAwMDAgbG9vcHM9MSkNCiAgICAgICAgIEJ1 ZmZlcnM6IHNoYXJlZCBoaXQ9NTUNCiBQbGFubmluZzoNCiAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9 MjMNCiBQbGFubmluZyBUaW1lOiAwLjI0MCBtcw0KIEpJVDoNCiAgIEZ1bmN0aW9uczogMw0KICAg T3B0aW9uczogSW5saW5pbmcgZmFsc2UsIE9wdGltaXphdGlvbiBmYWxzZSwgRXhwcmVzc2lvbnMg dHJ1ZSwgRGVmb3JtaW5nCnRydWUNCiAgIFRpbWluZzogR2VuZXJhdGlvbiAwLjE5MyBtcyAoRGVm b3JtIDAuMDU2IG1zKSwgSW5saW5pbmcgMC4wMDAgbXMsCk9wdGltaXphdGlvbiAwLjE3NSBtcywg RW1pc3Npb24gMy4yOTAgbXMsIFRvdGFsIDMuNjU4IG1zDQogRXhlY3V0aW9uIFRpbWU6IDgxNzIu MDE4IG1zDQooMTIgcm93cykNCmBgYA0KDQpbMl0NCmBgYA0KPCA7IE1vZHVsZUlEID0gJzM5NzQ5 MS45ODYuYmMnDQotLS0NCj4gOyBNb2R1bGVJRCA9ICczOTc0OTEuNjExLmJjJw0KMTVjMTUNCjwg ZGVmaW5lIG5vdW5kZWYgaTY0IEBldmFsZXhwcl85ODZfMChwdHIgbm9jYXB0dXJlIG5vdW5kZWYg d3JpdGVvbmx5ICUwLCBwdHIKJTEsIHB0ciAlMikgIzAgew0KLS0tDQo+IGRlZmluZSBub3VuZGVm IGk2NCBAZXZhbGV4cHJfNjExXzAocHRyIG5vY2FwdHVyZSBub3VuZGVmIHdyaXRlb25seSAlMCwg cHRyCiUxLCBwdHIgJTIpICMwIHsNCmBgYA0KDQpbM10NCmBgYA0KQ1JFQVRFIEFHR1JFR0FURSBj dXN0b21fYWdnX2F2ZyAoZmxvYXQ4KQ0KKA0KICAgIHNmdW5jID0gZmxvYXQ4X2FjY3VtLA0KICAg IHN0eXBlID0gZmxvYXQ4W10sDQogICAgZmluYWxmdW5jID0gZmxvYXQ4X2F2ZywNCiAgICBpbml0 Y29uZCA9ICd7MCwwLDB9Jw0KKTsNCmBgYAoK --===============2332314996577310057==--