| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Alexander Borisov <lex(dot)borisov(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Optimization for lower(), upper(), casefold() functions. |
| Date: | 2025-03-14 03:43:49 |
| Message-ID: | 2a9e520ba41b318df8ed396ef99ed1e3d3e4b5b6.camel@j-davis.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| v6j-0001-Optimization-for-lower-upper-casefold-functions.patch | text/x-patch | 765.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2025-03-14 05:04:20 | RE: Skip collecting decoded changes of already-aborted transactions |
| Previous Message | David Rowley | 2025-03-14 03:14:25 | Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET |