Re: Optimization for lower(), upper(), casefold() functions.

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Optimization for lower(), upper(), casefold() functions.
Дата
Msg-id 2a9e520ba41b318df8ed396ef99ed1e3d3e4b5b6.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: Optimization for lower(), upper(), casefold() functions.  (Alexander Borisov <lex.borisov@gmail.com>)
Ответы Re: Optimization for lower(), upper(), casefold() functions.
Список pgsql-hackers
On Wed, 2025-03-12 at 23:39 +0300, Alexander Borisov wrote:
> v5 attached.

Attached v6j.

* marked arrays as "static const" rather than just "static"
* ran pgindent
* changed data types where appropriate (uint32->pg_wchar)
* modified perl code so that it produces code that's already pgindented
* cleanup of perl code, removing unnecessary subroutines and variables
* added a few comments
* ran pgperltidy

Some of the perl code working with ranges still needs further cleanup
and explanation, though.

Also, I ran some of my own simple tests (mostly ASCII) and it showed
over 10% speedup. That combined with the smaller table sizes makes this
well worth it.

Regards,
    Jeff Davis


Вложения

В списке pgsql-hackers по дате отправления: