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: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-05-13T03:23:17Z
Lists: pgsql-hackers 
On Wed, May 12, 2021 at 06:06:31PM -0400, Álvaro Herrera wrote:
> On 2021-May-12, Bruce Momjian wrote:
> 
> > OK, I added it into the existing entry:
> > 
> > 	<listitem>
> > 	<!--
> > 	Author: Alexander Korotkov <akorotkov@postgresql.org>
> > 	2021-01-31 [676887a3b] Implementation of subscripting for jsonb
> > 	Author: Alexander Korotkov <akorotkov@postgresql.org>
> > 	2021-01-31 [81fcc72e6] Filling array gaps during jsonb subscripting
> > 	Author: Alexander Korotkov <akorotkov@postgresql.org>
> > 	2021-01-31 [aa6e46daf] Throw error when assigning jsonb scalar instead of a com
> > 	-->
> > 	
> > 	<para>
> > 	Allow subscripting of jsonb (Dmitry Dolgov)
> > 	</para>
> > 	
> > 	<para>
> > 	Subscripting can be used to extract from and assign to jsonb documents.
> > 	Subscripting is now extensible so extensions and built-in data type can make use of this.
> > 	</para>
> > 	</listitem>
> 
> I dunno, this seems to approach the feature from the specifics rather
> than its full generality.  I would have said something like 
> 
>  Make subscripting user-extensible for "container" types
>     <!-- maybe "array-like types" -->
> 
>   Subscripting JSONB is now integrated in core, and adding user-defined
>   subscripting for other types is possible.

I wanted to highlight the more useful aspect of this change, which I
think is JSBONB subscripting.  Here is an updated version.  Changes?

	<listitem>
	<!--
	Author: Alexander Korotkov <akorotkov@postgresql.org>
	2021-01-31 [676887a3b] Implementation of subscripting for jsonb
	Author: Alexander Korotkov <akorotkov@postgresql.org>
	2021-01-31 [81fcc72e6] Filling array gaps during jsonb subscripting
	Author: Alexander Korotkov <akorotkov@postgresql.org>
	2021-01-31 [aa6e46daf] Throw error when assigning jsonb scalar instead of a com
	-->
	
	<para>
	Allow subscripting of JSONB and simplify the implementation of subscripting
	(Dmitry Dolgov)
	</para>
	
	<para>
	JSONB subscripting can be used to extract from and assign to JSONB
	documents.  Extensions and built-in data types can now implement
	subscripting more easily.
	</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