Re: Improve the performance of Unicode Normalization Forms. - Mailing list pgsql-hackers

From Alexander Borisov
Subject Re: Improve the performance of Unicode Normalization Forms.
Date
Msg-id a2ba2920-cdd6-43e5-a9ac-079adcb2ff78@gmail.com
Whole thread Raw
In response to Re: Improve the performance of Unicode Normalization Forms.  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
20.09.2025 04:03, Jeff Davis wrote:
> On Thu, 2025-09-11 at 20:51 +0300, Alexander Borisov wrote:
>>
>>> Hey.
>>>
>>> I've looked into these patches.
>>
>> Hi Victor,
>>
>> Thank you for reviewing the patch and testing it!
> 
> Heikki, do you have thoughts on this thread?

Hey,

In patch v5 (attached), I changed the approach to class caching.
Now, for small texts (less than 512 characters), we don't allocate
memory from the heap; we use the stack.

And according to pgbench tests, we have a 2x speedup.
According to Jeff's tests, we have a 10x speedup.
According to tests from the thread
https://www.postgresql.org/message-id/CAFBsxsHUuMFCt6-pU+oG-F1==CmEp8wR+O+bRouXWu6i8kXuqA@mail.gmail.com,
we also have a 2x speedup.


--
Regards,
Alexander Borisov

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Remove Item type
Next
From: Greg Burd
Date:
Subject: Re: [PATCH] Add tests for Bitmapset