Re: First draft of PG 17 release notes

Masahiko Sawada <sawada.mshk@gmail.com>

From: Masahiko Sawada <sawada.mshk@gmail.com>

To: Bruce Momjian <bruce@momjian.us>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2024-05-09T05:17:12Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Revert support for ALTER TABLE ... MERGE/SPLIT PARTITION(S) commands
- 3890d90c1508 18.0 cited
When creating materialized views, use REFRESH to load data.
- b4da732fd64e 17.0 cited
Revert temporal primary keys and foreign keys
- 8aee330af55d 17.0 cited
Avoid needless large memcpys in libpq socket writing
- c4ab7da60617 17.0 cited
Enhance nbtree ScalarArrayOp execution.
- 5bf748b86bc6 17.0 cited
Introduce a non-recursive JSON parser
- 3311ea86edc7 17.0 cited
Combine freezing and pruning steps in VACUUM
- 6dbb490261a6 17.0 cited
Allow SIGINT to cancel psql database reconnections.
- cafe1056558f 17.0 cited
Provide API for streaming relation data.
- b5a9b18cd0bc 17.0 cited
Add hash support functions and hash opclass for contrib/ltree.
- 485f0aa85995 17.0 cited
Pull up ANY-SUBLINK with the necessary lateral support.
- 9f133763961e 17.0 cited
Read WAL directly from WAL buffers.
- 91f2cae7a4e6 17.0 cited
Introduce the dynamic shared memory registry.
- 8b2bcf3f287c 17.0 cited
Add macros for looping through a List without a ListCell.
- 14dd0f27d7cd 17.0 cited
Support +/- infinity in the interval data type.
- 519fc1bd9e9d 17.0 cited
Extend ALTER OPERATOR to allow setting more optimization attributes.
- 2b5154beab79 17.0 cited
Consider cheap startup paths in add_paths_to_append_rel
- a8a968a8212e 17.0 cited

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)

Also, please consider the following item:

- Improve eviction algorithm in ReorderBuffer using max-heap for many
subtransactions (5bec1d6bc)

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)

Regards,

-- 
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com