From: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PG 14 release notes, first draft |
Date: | 2021-05-10 18:42:08 |
Message-ID: | CAFBsxsHVv5g2qDRwBEPVNq2+hhF5qThxS+6_MKaaa4-=xxSQkA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
> 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 <michael(at)paquier(dot)xyz>
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode
Normalization quick check
--
John Naylor
EDB: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-05-10 20:17:18 | Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS |
Previous Message | Tom Lane | 2021-05-10 18:38:05 | Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS |