From: Jeff Davis <pgsql@j-davis.com>
To: Alexander Borisov <lex.borisov@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Improve the performance of Unicode Normalization Forms.
Date: Fri, 20 Jun 2025 10:20:08 -0700
Message-ID: <96c54fc3dde2ebaccafbd1ffa29b8be1005c8b8c.camel@j-davis.com> (raw)
In-Reply-To: <16f87504-f174-450e-93cc-2db1074522bb@gmail.com>
References: <844d3dd7-2955-4794-95d1-7f4c13cb89fc@gmail.com>
<4211ffd7fe154c4af693b98d78f4a3689ce8cc30.camel@j-davis.com>
<16f87504-f174-450e-93cc-2db1074522bb@gmail.com>
On Fri, 2025-06-20 at 17:51 +0300, Alexander Borisov wrote:
> I don't quite see how this compares to the implementation on Rust. In
> the link provided, they use perfect hash, which I get rid of and get
> a x2 boost.
> If you take ICU implementations in C++, I have always considered them
> slow, at least when used in C code.
> I may well run benchmarks and compare the performance of the approach
> in Postgres and ICU. But this is beyond the scope of the patches
> under
> discussion.
Are you saying that, with these patches, Postgres will offer the
fastest open-source Unicode normalization? If so, that would be very
cool.
The reason I'm asking is because, if there are multiple open source
implementations, we should either have the best one, or just borrow
another one as long as it has a suitable license (perhaps translating
to C as necessary).
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pgsql@j-davis.com, lex.borisov@gmail.com
Subject: Re: Improve the performance of Unicode Normalization Forms.
In-Reply-To: <96c54fc3dde2ebaccafbd1ffa29b8be1005c8b8c.camel@j-davis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox