Request a Demo
Home   >   mailing lists

Re: PG 14 release notes, first draft - Mailing list pgsql-hackers

From John Naylor
Subject Re: PG 14 release notes, first draft
Date
Msg-id CAFBsxsHVv5g2qDRwBEPVNq2+hhF5qThxS+6_MKaaa4-=xxSQkA@mail.gmail.com
Whole thread Raw
In response to PG 14 release notes, first draft  (Bruce Momjian <bruce@momjian.us>)
Responses Re: PG 14 release notes, first draft
List pgsql-hackers
Tree view
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@paquier.xyz>
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization quick check

--

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS
Next
From: Tom Lane
Date:
Subject: Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS