[gavinray]

Highlights below are huge!

Does anyone know whether there is active work being done to incorporate the prototype of Incremental View Maintenance (IVM) for auto-updating Materialized Views?

This feature is the one I am most excited about. On Dockerhub, "yugonagata/postgresql-ivm" provides a working implementation but it's been around for some time now:

https://pgsqlpgpool.blogspot.com/2019/08/automatically-updat...

---------

  This release has significant improvements in transaction throughput for PostgreSQL systems that have large numbers of connections to the database, regardless if they are in an active or idle state.

  There are many improvements to query parallelism in PostgreSQL 14. In addition to overall performance improvements for parallel sequential scans, the RETURN QUERY directive in PL/pgSQL can now execute queries with parallelism. REFRESH MATERIALIZED VIEW can now use query parallelism as well.

  PostgreSQL 14 now adds a general subscripting framework for retrieving information in nested objects. For example, you can now retrieve nested info in the JSONB data type using subscript syntax:

  SELECT ('{ "this": { "now": { "works": "in postgres 14!" }}}'::jsonb)['this']['now']['works'];