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

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Alexander Borisov <lex.borisov@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, pgsql-hackers@postgresql.org

Date: 2025-03-15T20:57:03Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix headerscheck warning.
- 549ea06e4217 18.0 landed
Optimization for lower(), upper(), casefold() functions.
- 27bdec06841d 18.0 landed
Refactor convert_case() to prepare for optimizations.
- d3b2e5e1ab5c 18.0 landed
Improve performance of Unicode {de,re}composition in the backend
- 783f0cc64dcc 14.0 cited

On Sat, Mar 15, 2025 at 1:11 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Jeff Davis <pgsql@j-davis.com> writes:
> > Committed. Thank you!
>
> crake doesn't like your perl style:
>
> ./src/common/unicode/generate-unicode_case_table.pl: Loop iterator is not
> lexical at line 638, column 2.  See page 108 of PBP.

I suppose pgperltidy didn't catch that. I will fix it shortly.

Regards,
      Jeff Davis