Re: Improve the performance of Unicode Normalization Forms.

From: Alexander Borisov <lex(dot)borisov(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improve the performance of Unicode Normalization Forms.
Date: 2025-07-07 18:44:03
Message-ID: 85f2a36f-f70a-4667-be48-49b652457295@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

30.06.2025 22:28, Jeff Davis пишет:
> 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.

After the discussion in this correspondence, we are settling on
the "small" patch option. The table size is reduced, the speed is
almost x2.
Attached are the final two patches. After reviewing/accepting them,
I will proceed to optimizing the C code for Unicode Normalization Forms.

--
Regards,
Alexander Borisov

Attachment Content-Type Size
v2-0001-Moving-Perl-functions-Range-index-to-a-common-mod.patch text/plain 12.4 KB
v2-0002-Improve-the-performance-of-Unicode-Normalization-.patch text/plain 1.0 MB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message John H 2025-07-07 18:45:58 Re: Making pg_rewind faster
Previous Message Tom Lane 2025-07-07 18:36:53 Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7