Horton
Menu

Re: First draft of PG 19 release notes

Andreas Karlsson <andreas@proxel.se>

View thread
From: Andreas Karlsson <andreas@proxel.se>
To: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-30T07:08:58Z
Lists: pgsql-hackers 
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

Commits

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

  1. doc PG 19 relnotes: remove VALIDATE CONSTRAINT lock item

  2. Fix ALTER DOMAIN VALIDATE CONSTRAINT locking

  3. Revert "Enable fast default for domains with non-volatile constraints"

  4. doc PG 19 relnotes: improve awkward or confusing wording

  5. doc PG 19 relnotes: more fixes

  6. doc PG 19 relnotes: various corrections

  7. doc PG 19 relnotes: adjust item to mention pg_replication_slots

  8. doc PG 19 relnotes: remove "Add fake LSN support to hash index"

  9. doc PG 19 relnotes: add two optimizer hooks

  10. doc PG 19 relnotes: remove "Optionally" for CPU optimizations

  11. doc PG 19 relnotes: adjustments/removal of items

  12. doc PG 19 relnotes: add UTF-8 case folding performance item

  13. doc PG 19 relnotes: correct two items

  14. doc PG 19 relnotes: add missing commits and details

  15. doc PG 19 relnotes: fix typo, "date" -> "data"

  16. doc PG 19 relnotes: add author and move items

  17. doc PG 19 relnotes: update author

  18. doc PG 19 relnotes: add free space map all-visible item

  19. doc PG 19 relnotes: remove "Lakshmi N" as author of checksums

  20. doc PG 19 relnotes: fix "now targets"

  21. doc PG 19 relnotes: adjust ShmemRequestStruct item

  22. Improve various new-to-v19 appendStringInfo calls

  23. doc: Fix data_checksums data type

  24. Fix WITHOUT OVERLAPS' interaction with domains.

  25. Online enabling and disabling of data checksums

  26. Doc: split functions-posix-regexp section into multiple subsections.

  27. make immutability tests in to_json and to_jsonb complete

  28. Optimize tuple deformation

  29. pgstattuple: Optimize pgstattuple_approx() with streaming read

  30. Use fake LSNs to improve nbtree dropPin behavior.

  31. Use streaming read for VACUUM cleanup of GIN

  32. Clean up ICU includes.

  33. ICU: use UTF8-optimized case conversion API

  34. Add the MODE option to the WAIT FOR LSN command

  35. Speedup tuple deformation with additional function inlining