Horton

Re: PG 14 release notes, first draft

Bruce Momjian <bruce@momjian.us>

View thread View on postgr.es
From: Bruce Momjian <bruce@momjian.us>
To: John Naylor <john.naylor@enterprisedb.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-05-13T03:15:06Z
Lists: pgsql-hackers 
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 <michael@paquier.xyz>
> 2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization
> quick check

OK, updated text:

	<listitem>
	<!--
	Author: Michael Paquier <michael@paquier.xyz>
	2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization
	Author: Michael Paquier <michael@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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Commits

  1. doc: add mention of +4GB windows file handling in PG14 relnotes

  2. doc: PG 14 relnotes fixes

  3. doc: PG 14 relnote updates

  4. doc: PG 14 relnotes, adjust pg_{read|write}_all_data entry

  5. Update PG 14 relnotes for vacuum_cost_page_miss

  6. doc: update PG 14 release notes with recent feedback

  7. Update replication statistics after every stream/spill.

  8. Add information of total data processed to replication slot stats.

  9. Use NameData datatype for slotname in stats.

  10. Add back vacuum_cleanup_index_scale_factor parameter.

  11. Don't consider newly inserted tuples in nbtree VACUUM.

  12. pgbench: Improve time logic.

  13. Track total amounts of times spent writing and syncing WAL data to disk.

  14. Allow decoding at prepare time in ReorderBuffer.

  15. Extend the output plugin API to allow decoding of prepared xacts.

  16. Fix nbtree cleanup-only VACUUM stats inaccuracies.

  17. Execute invalidation messages for each XLOG_XACT_INVALIDATIONS message

  18. Fix our Windows stat() emulation to handle file sizes > 4GB.

  19. Trigger autovacuum based on number of INSERTs

  20. Speed up planning when partitions can be pruned at plan time.

  21. Remove support for password_encryption='off' / 'plain'.

  22. Increase work_mem and maintenance_work_mem defaults by 4x