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 1uWKCO-00CEMl-Iw for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jun 2025 19:29:52 +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 1uWKBO-001qKE-LW for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jun 2025 19:28:51 +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 1uWKBO-001qK5-Bd for pgsql-hackers@lists.postgresql.org; Mon, 30 Jun 2025 19:28:50 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uWKBN-004oTT-1W for pgsql-hackers@postgresql.org; Mon, 30 Jun 2025 19:28:50 +0000 Received: by mail-oi1-x231.google.com with SMTP id 5614622812f47-40aef72f252so1516658b6e.0 for ; Mon, 30 Jun 2025 12:28:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1751311729; x=1751916529; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=R0RqcqBEKsyA/HhUydtz/CLvKmiMtbCNYQP7cIpC/Iw=; b=pbHcASfGPsa48y6kKdIKRkByJw8X19oM73QT4a6S0tQ72SAqqC+1H9eWhxUcCv6+Rh fJLoK5m5jkh6a5Syk5Gy+sAyz8zzYRXSAfsadAM8SAEHrWV5Md8n3PN4JqhkKRqm//bk dBMqirR3UYjxlMg/fT7mwurKHQ0xXYQhSoEuPfDMwGQX/ETrgU4f8D3wMcxXFuuHQvuT O0t4n7kVTcF4bqhRPGuoTeqm7BYKnZG5u3paBVRY/Fm0leyN3XW2YPYDnb0miuJMmpfi 9w6suMjVBscP5Q9jmW4ssLKxuHkkRQ5wlsjo2yTBSVYIPZ8lhzYSq465Lxmy2mCnnCic FPKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1751311729; x=1751916529; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=R0RqcqBEKsyA/HhUydtz/CLvKmiMtbCNYQP7cIpC/Iw=; b=fAZY84uwZwU+vAjIB8o9jqCkGfVw0qhPJvDx+EDfCKbsGPJLC166Edw0A7Z3HM+TdR XNbxWhdoJvdPvs5sH00egDclQY2NNoKNUtqlorbMAXqGB9XaWjgrpVWp7SqSrdGpJhW6 s9h8ORp7bAlPrrNuf5j7ljnUT5NEg1ynCeBuxWbI9DA/IT/NhQYGukH1gXWVZCysBqIv eEO6x6zAzvP46s7qVUciheOTz5chBaIeMCUOX7t7aMhKosJs/xnZFrXHHdboIh3+hnqO nIVtoh4aC/7Dxkou+YsI1OuVcf5HnejUL7DVy3LCSuornDH2jT5g4xHk706wFbv4sx7U X/Lg== X-Forwarded-Encrypted: i=1; AJvYcCUSkAjE4Svqrb02KqNMIpymKyPV+Hr4mdQkKmL0L2blw28QrY2LaMPTDjSAOoPtrmcpiUYV0x8t3LdqeR3q@postgresql.org X-Gm-Message-State: AOJu0YwHL3WT5q7g7FIDByTGkTBdKjJL3mpBxWcGqx0RxjVrq2nUFSLM eunteiP1p7ZI+i8WGezc02afqA3rFHo3c8cSPLyPuAMUmwUsXNjgbzIliTSomnWybw== X-Gm-Gg: ASbGnctdQcS20/JgwhNZ3g1KVpNBK0wj95TfdmFwhG9MCMN9lgT72uc2MROB1iOY1KH zcXeR0PFPAzIm8v0OgPaCFEwvtRMfu5gb6gIU3/znKVM4lbMliUgbzQi1qFtyH6gXj41M/hdJXb lB7XOl4d7eZ+26DM3of4cJH+xhXYmFML/E7tDL6N2KCi9QU2Xny0+3bCv6cfD6QKRlR6ezR31f+ FqX/oq3uskDtlODP2syXj7icuVK6CKer/N1WPNYC1yufqqoAdBoiH9TO3wNftMYsmfz9HjQffmn QGRBArCKeE5CT28V71Rc8hYbxAo+lkfjmYugKfzFmYNW3v1XvJ3xrsW0kVsYxyw1UTh8q0gIxZj QzYWX7qR9530oBqUZCCRTNB6FSJQW62D4JUU/ezy3UIQ= X-Google-Smtp-Source: AGHT+IE1pcOPFrufPpEQHqVC5Eg2KXPob9SyHIHE7vsRJDMjavrRapIytbDrNEua1Rt12x3rLf3KmQ== X-Received: by 2002:a05:6808:6f97:b0:3f9:2fdc:ee93 with SMTP id 5614622812f47-40b33e2eca2mr11387346b6e.30.1751311728759; Mon, 30 Jun 2025 12:28:48 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 006d021491bc7-611b85a0f8asm1237519eaf.31.2025.06.30.12.28.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 Jun 2025 12:28:48 -0700 (PDT) Message-ID: <599663a8d5948243bd87bf55a4f76bbb4a51a6e8.camel@j-davis.com> Subject: Re: Improve the performance of Unicode Normalization Forms. From: Jeff Davis To: Alexander Borisov , PostgreSQL Hackers Date: Mon, 30 Jun 2025 12:28:47 -0700 In-Reply-To: <677cde50-6d64-474b-9ba8-bab380a111b3@gmail.com> References: <844d3dd7-2955-4794-95d1-7f4c13cb89fc@gmail.com> <4211ffd7fe154c4af693b98d78f4a3689ce8cc30.camel@j-davis.com> <16f87504-f174-450e-93cc-2db1074522bb@gmail.com> <96c54fc3dde2ebaccafbd1ffa29b8be1005c8b8c.camel@j-davis.com> <677cde50-6d64-474b-9ba8-bab380a111b3@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-06-24 at 18:20 +0300, Alexander Borisov wrote: > That's what we're aiming for - to implement the fastest approach. Awesome! Thank you for clarifying this as a goal. Having the fastest open-source Unicode normalization would be a great thing to highlight when this is done. Regards, Jeff Davis