Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 27 Mar 2026 08:12:31 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Alexander Borisov <lex.borisov@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Jeff Davis <pgsql@j-davis.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Improve the performance of Unicode Normalization Forms.
Message-ID: <acW9Xyld980eorPV@paquier.xyz>
References: <5f8639d99dab0d95dc1ef8f3abd4aa3adc0332ee.camel@j-davis.com>
 <e2e771aa-87aa-46d8-b547-8e73d49207f1@gmail.com>
 <ec5c5854-226b-4105-88e1-efa7dc05fba4@iki.fi>
 <58c6cea8-a5b1-4a8a-8044-18ef0011a168@gmail.com>
 <f584418b-c704-4308-b1cb-b667d99c0c6f@iki.fi>
 <7b76973b-e9b6-4f80-a1d2-4bd467e38346@gmail.com>
 <24338db8-59f2-42a4-a7de-735cf8f12119@gmail.com>
 <af239a46-8869-4ac3-a47f-75abcc0125cb@gmail.com>
 <acN808rQU_mTu-zt@paquier.xyz>
 <fe3bb776-bf6d-40f9-b83a-f64b0948cf6f@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="MvgsA/v7uiDm8RQt"
Content-Disposition: inline
In-Reply-To: <fe3bb776-bf6d-40f9-b83a-f64b0948cf6f@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/acW9Xyld980eorPV%40paquier.xyz>
Precedence: bulk


--MvgsA/v7uiDm8RQt
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Mar 26, 2026 at 06:13:36PM +0300, Alexander Borisov wrote:
> Attached rebased patches and Perl script (generate_NF_C_D_KC_KD_sql.pl)
> for generating test files.  At the beginning of the script, there is
> a description of how to use it and what it generates.

Thanks.  That's going to be handy.  One thing I am not sure of is if
Jeff and/or Heikki are planning to come back to this thread by the
feature freeze and do something about it for v19.

So let's see what happens, but I'll be happy to study this patch
opportunity in v20, be it in a complete form or a partial form (for
the latter we could assume that a portion of what you are suggesting
is committed into the tree in time for v19, leaving some hanging
fruits for v20).
--
Michael

--MvgsA/v7uiDm8RQt
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnFvV8ACgkQnvQgOdby
QH2f2w/8CpNVdfkqvmjjE/PUG/roUhkJ6pGVBEh5lXfaNEpnqvaKansPv3Fl0YWX
WdC+aiMuJvuq+BRvwUbC/pfHT1krDK2tHNLI6ugToZBpWlh+P4hoFR036j54USyp
7Wy4ztVllkEBwC29t4nDoEf2N974vVu0w1bpJtOMQCQuoDhmmJJmU0neaZbnAWoo
+s02N/lAWcX0Y9zDoPOFTOYDMIV9x3HeH7KGylNwW5CVB3H+qIbAWafkFZ0XYvH3
fljMQiiPDnms03N+FGVFGZkY+fq3WvtpDVhx346r58FsU180wBOp172Mh5TGRKvN
HSabaxQM0B7Tk/ITpjo5Glr1wRrAf0Og5xNWqRcJTbTkLeF3LxwSTXuGLRsJl/Zb
jDRUsq8YdyZrSqZEvVdJXXzz2Gq3PWBbkDY83VhRnHvKzEpBQ9B5jjf+4H8yuUBL
uFn002KuciSv+h9veU+DlY+mBsrzxihFmZKXhJBYicDw7rDYLgmGsu4NG2cyNIhR
+b2H28IqeQJQMdh/gmkXIVN6yQz1Ev+HcfPPpffIoOYpXR7X7LNseailaQ/t0988
Knx67SjKISOj0oo4PZLjpAwqtRBaT2sGlaYrP6zK1kqgtvFmgR8PAg+97CQb9DPv
yanAqObBC0/H+Mxhf8tiNm1iBfrZOrhysCRnQjEZQgbuN7Uq6t4=
=l6kc
-----END PGP SIGNATURE-----

--MvgsA/v7uiDm8RQt--