Date: Thu, 9 May 2024 09:48:41 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: First draft of PG 17 release notes
Message-ID: <ZjzUOdSTpEw4Dnyf@momjian.us>
References: <ZjxLJpnH4VMkOMmi@momjian.us>
 <CAD21AoC2H-q-4nz7wr_xSC59OUkZVuc+sHu+9thfWqNpeFhGcQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAD21AoC2H-q-4nz7wr_xSC59OUkZVuc+sHu+9thfWqNpeFhGcQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/ZjzUOdSTpEw4Dnyf%40momjian.us>
Precedence: bulk

On Thu, May  9, 2024 at 02:17:12PM +0900, Masahiko Sawada wrote:
> Hi,
> 
> On Thu, May 9, 2024 at 1:03 PM Bruce Momjian <bruce@momjian.us> wrote:
> >
> > I have committed the first draft of the PG 17 release notes;  you can
> > see the results here:
> >
> >         https://momjian.us/pgsql_docs/release-17.html
> 
> Thank you for working on that!
> 
> I'd like to mention some of my works. I think we can add the vacuum
> performance improvements by the following commits:
> 
> - Add template for adaptive radix tree (ee1b30f1)
> - Add TIDStore, to store sets of TIDs (ItemPointerData) efficiently (30e144287)
> - Use TidStore for dead tuple TIDs storage during lazy vacuum (667e65aac)

Okay, I reworded the item, added authors, and added the commits:

	<!--
	Author: John Naylor <john.naylor@postgresql.org>
	2024-03-07 [ee1b30f12] Add template for adaptive radix tree
	Author: Masahiko Sawada <msawada@postgresql.org>
	2024-03-21 [30e144287] Add TIDStore, to store sets of TIDs (ItemPointerData) ef
	Author: Masahiko Sawada <msawada@postgresql.org>
	2024-04-02 [667e65aac] Use TidStore for dead tuple TIDs storage during lazy vac
	Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
	2024-04-03 [6dbb49026] Combine freezing and pruning steps in VACUUM
	-->
	
	<listitem>
	<para>
	Allow vacuum to more efficiently remove and freeze tuples (John Naylor, Masahiko Sawada, Melanie Plageman)
	</para>
	</listitem>

> Also, please consider the following item:
> 
> - Improve eviction algorithm in ReorderBuffer using max-heap for many
> subtransactions (5bec1d6bc)

I looked at that item and I don't have a generic "make logical
replication apply faster" item to merge it into, and many
subtransactions seemed like enough of an edge-case that I didn't think
mentioning it make sense.  Can you see a good place to add it?

> Finally, should we mention the following commit in the release note?
> It's not a user-visible change but added a new regression test module.
> 
> - Add tests for XID wraparound (e255b646a)

I don't normally add testing infrastructure changes unless they are
major.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.