Horton

Re: PG 14 release notes, first draft

Amit Langote <amitlangote09@gmail.com>

View thread View on postgr.es
From: Amit Langote <amitlangote09@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-05-14T01:40:42Z
Lists: pgsql-hackers 
On Thu, May 13, 2021 at 11:59 PM Bruce Momjian <bruce@momjian.us> wrote:
> On Thu, May 13, 2021 at 02:46:58PM +0900, Amit Langote wrote:
> > How about writing the 2nd line instead as:
> >
> > Updates/deletes on partitioned tables can now use execution-time
> > partition pruning.
> >
> > We don't seem to use the term "run-time pruning" anywhere else in the
> > documentation, and "pruning of updates/deletes" sounds strange.
>
> Good point, updated text:
>
>         <listitem>
>         <!--
>         Author: Tom Lane <tgl@sss.pgh.pa.us>
>         2021-03-31 [86dc90056] Rework planning and execution of UPDATE and DELETE.
>         Author: Tom Lane <tgl@sss.pgh.pa.us>
>         2021-04-06 [a1115fa07] Postpone some more stuff out of ExecInitModifyTable.
>         Author: Tom Lane <tgl@sss.pgh.pa.us>
>         2021-04-06 [c5b7ba4e6] Postpone some stuff out of ExecInitModifyTable.
>         -->
>
>         <para>
>         Improve the performance of updates/deletes on partitioned tables
>         when only a few partitions are affected (Amit Langote, Tom Lane)
>         </para>
>
>         <para>
>         This also allows updates/deletes on partitioned tables to use
>         execution-time partition pruning.
>         </para>
>         </listitem>

Thank you.

-- 
Amit Langote
EDB: http://www.enterprisedb.com

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