| 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: | Whole Thread | Raw Message | 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 |