On Mon, May 10, 2021 at 02:42:08PM -0400, John Naylor wrote: > Hi Bruce, > > Thanks for doing this work again! > > > Add date_bin function (John Naylor) > > > > WHAT DOES THIS DO? > > Hard to describe in a one-liner, but it lines up timestamps into regular > intervals as specified by the user. It is more clear after seeing examples: > > https://www.postgresql.org/docs/devel/functions-datetime.html# > FUNCTIONS-DATETIME-BIN
OK, I just copied the doc sentence into the release notes. > > Dramatically improve Unicode normalization (John Naylor) > > > > WHAT OPERATIONS USE THIS? > > PG13 added the normalize() function to normalize Unicode sequences, as well as > the IS NORMALIZED syntax to test for that. The commits* here do not change > behavior and only improve performance. As such, this really belongs in the > performance section. > > *There is one additional commit that belongs to this entry: > > Author: Michael Paquier <mich...@paquier.xyz> > 2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization > quick check OK, updated text: <listitem> <!-- Author: Michael Paquier <mich...@paquier.xyz> 2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization Author: Michael Paquier <mich...@paquier.xyz> 2020-10-23 [783f0cc64] Improve performance of Unicode {de,re}composition in the --> <para> Dramatically improve Unicode normalization (John Naylor) </para> <para> This speeds normalize() and IS NORMALIZED. </para> </listitem> -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.