On 4/15/26 3:18 AM, Bruce Momjian wrote:
> I have completed the first draft of the PG 19 release notes:
Thanks!
I noticed that two of my performance patches were not included in the
release notes and I personally think one of them belongs in the release
notes while other not.
The one I think belongs is the one below since it it really results in
major speedups of lower(), upper(), initcap() and casefold() on ICU with
UTF-8. Not having to convert from UTF-8 to UTF-32 and back is often a
major speedup.
commit c4ff35f10441de7dbed4e87737bca205dcca698e
Author: Jeff Davis <jdavis@postgresql.org>
Date: Tue Jan 6 14:09:07 2026 -0800
ICU: use UTF8-optimized case conversion API
Initializes a UCaseMap object once for use across calls, and uses
UTF8-optimized APIs.
Author: Andreas Karlsson <andreas@proxel.se>
Reviewed-by: zengman <zengman@halodbtech.com>
Discussion:
https://postgr.es/m/5a010b27-8ed9-4739-86fe-1562b07ba564@proxel.se
--
Andreas Karlsson
Percona