Re: PG 18 relnotes and RC1
Nathan Bossart <nathandbossart@gmail.com>
From: Nathan Bossart <nathandbossart@gmail.com>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>, corey.huinker@gmail.com, Erik Rijkers <er@xs4all.nl>
Date: 2025-09-19T16:50:03Z
Lists: pgsql-hackers
Attachments
On Fri, Sep 19, 2025 at 09:25:52AM -0500, Nathan Bossart wrote: > I'm hoping to commit this around 20:00 UTC today, and I will be happy to > address any feedback that folks have in the meantime. Here's a v4. The content is the same except for a typo fix, some formatting adjustments that don't change anything in the generated page, and a real commit message. I'm okay with the content, but I figured I'd note some thoughts: + An asynchronous I/O subsystem (AIO) that can improve performance of + sequential scans, bitmap heap scans, vacuums, and other operations. I wondered whether we should put "(AIO)" before "subsystem", but I think putting it next to "I/O" makes the line too busy. Also, are there "other operations", or is the rest of the list complete? + <link linkend="pgupgrade"><application>pg_upgrade</application></link> + now maintains optimizer statistics through upgrade. I think "retain" might be a better verb than "maintain", but the meaning seems clear either way. Also, while we could probably omit "through upgrade", the small amount of redundancy does (IMHO) reinforce the meaning a bit. + Support for "skip scan" lookups that allow + <link linkend="indexes-multicolumn">multicolumn B-tree indexes</link> to + be used in more cases. Passive voice. Perhaps this should be "that allow using ... in more cases." + <link linkend="sql-createtable-parms-generated-stored">generated columns</link> + that compute their values during read operations. This is now the + default for generated columns. I liked the phrase "just-in-time" for this because it expresses how it works. Perhaps we should squeeze that in before "during read operations". -- nathan
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Add list of major features to the v18 release notes.
- b585f25284d2 18.0 landed
-
add_commit_links.pl: error out if missing major version number
- 0c6d572c1173 19 (unreleased) landed
-
doc PG 18 relnotes: Add migration note about tsearch
- d1073c3b4cc8 18.0 cited
-
Remove ts_locale.c's lowerstr()
- fb1a18810f07 18.0 cited