add list of major features to the v19 release notes

Started by Nathan Bossart5 months ago26 messageshackers
Jump to latest
#1Nathan Bossart
nathandbossart@gmail.com

Here's a first try at $subject. I used the 19beta1 announcement as a
guide.

--
nathan

Attachments:

v1-0001-Add-list-of-major-features-to-the-v19-release-not.patchtext/plain; charset=us-asciiDownload+78-2
#2Michael Banck
mbanck@gmx.net
In reply to: Nathan Bossart (#1)
Re: add list of major features to the v19 release notes

Hi,

yay for having this in place earlier this time.

Some comments:

On Wed, Jul 01, 2026 at 04:38:14PM -0500, Nathan Bossart wrote:

+    <listitem>
+     <para>
+      Logical replication now
+      <link linkend="logical-replication-sequences">replicates sequence values</link>,
+      and it can be enabled without a server restart when
+      <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
+     </para>
+    </listitem>

Maybe it's because I'm not a native speaker, but I tripped over the
second part and parsed it as a function of the replicate sequence
values, not logical replication. Would it help readers to drop the "it",
i.e. write "and can be enabled [...]"?

+    <listitem>
+     <para>
+      Faster performance in many areas, including automatic scaling of the
+      number of <link linkend="guc-io-max-workers">I/O worker processes</link>,
+      quicker foreign-key checks, and further planning and execution
+      optimizations.
+     </para>
+    </listitem>

(This is kinda a catch-all statement and might go well as last item,
dunno).

+    <listitem>
+     <para>
+      Data checksums can now be
+      <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.
+     </para>
+    </listitem>

I think we still don't say "the database" when we talk about a
server/instance/cluster. It should either be "the cluster" or "the
database server".

+    <listitem>
+     <para>
+      <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now
+      change or remove data for just part of a time range via the new
+      <literal>FOR PORTION OF</literal> clause.
+     </para>
+    </listitem>

I think this sentence should include something about temporal
ranges/keys, or maybe just s/time range/temporal range/?

Michael

#3Michael Banck
mbanck@gmx.net
In reply to: Nathan Bossart (#1)
Re: add list of major features to the v19 release notes

Hi,

yay for having this in place earlier this time.

Some comments:

On Wed, Jul 01, 2026 at 04:38:14PM -0500, Nathan Bossart wrote:

+    <listitem>
+     <para>
+      Logical replication now
+      <link linkend="logical-replication-sequences">replicates sequence values</link>,
+      and it can be enabled without a server restart when
+      <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
+     </para>
+    </listitem>

Maybe it's because I'm not a native speaker, but I tripped over the
second part and parsed it as a function of the replicate sequence
values, not logical replication. Would it help readers to drop the "it",
i.e. write "and can be enabled [...]"?

+    <listitem>
+     <para>
+      Faster performance in many areas, including automatic scaling of the
+      number of <link linkend="guc-io-max-workers">I/O worker processes</link>,
+      quicker foreign-key checks, and further planning and execution
+      optimizations.
+     </para>
+    </listitem>

(This is kinda a catch-all statement and might go well as last item,
dunno).

+    <listitem>
+     <para>
+      Data checksums can now be
+      <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.
+     </para>
+    </listitem>

I think we still don't say "the database" when we talk about a
server/instance/cluster. It should either be "the cluster" or "the
database server".

+    <listitem>
+     <para>
+      <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now
+      change or remove data for just part of a time range via the new
+      <literal>FOR PORTION OF</literal> clause.
+     </para>
+    </listitem>

I think this sentence should include something about temporal
ranges/keys, or maybe just s/time range/temporal range/?

Michael

#4Nathan Bossart
nathandbossart@gmail.com
In reply to: Nathan Bossart (#1)
Re: add list of major features to the v19 release notes

On Thu, Jul 02, 2026 at 01:15:39PM +0200, Michael Banck wrote:

On Wed, Jul 01, 2026 at 04:38:14PM -0500, Nathan Bossart wrote:

+    <listitem>
+     <para>
+      Logical replication now
+      <link linkend="logical-replication-sequences">replicates sequence values</link>,
+      and it can be enabled without a server restart when
+      <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.
+     </para>
+    </listitem>

Maybe it's because I'm not a native speaker, but I tripped over the
second part and parsed it as a function of the replicate sequence
values, not logical replication. Would it help readers to drop the "it",
i.e. write "and can be enabled [...]"?

Fixed.

+    <listitem>
+     <para>
+      Faster performance in many areas, including automatic scaling of the
+      number of <link linkend="guc-io-max-workers">I/O worker processes</link>,
+      quicker foreign-key checks, and further planning and execution
+      optimizations.
+     </para>
+    </listitem>

(This is kinda a catch-all statement and might go well as last item,
dunno).

Moved.

+    <listitem>
+     <para>
+      Data checksums can now be
+      <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>.
+     </para>
+    </listitem>

I think we still don't say "the database" when we talk about a
server/instance/cluster. It should either be "the cluster" or "the
database server".

Fixed.

+    <listitem>
+     <para>
+      <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now
+      change or remove data for just part of a time range via the new
+      <literal>FOR PORTION OF</literal> clause.
+     </para>
+    </listitem>

I think this sentence should include something about temporal
ranges/keys, or maybe just s/time range/temporal range/?

How about something like this?

Support for temporal updates and deletes via the new FOR PORTION OF
clause.

--
nathan

Attachments:

v2-0001-Add-list-of-major-features-to-the-v19-release-not.patchtext/plain; charset=us-asciiDownload+78-2
#5Nathan Bossart
nathandbossart@gmail.com
In reply to: Nathan Bossart (#4)
Re: add list of major features to the v19 release notes

On Thu, Jul 02, 2026 at 09:36:46AM -0500, Nathan Bossart wrote:

Subject: [PATCH v2 1/1] Add list of major features to the v19 release notes.

Barring more feedback, I'd like to proceed with this patch sooner than
later.

--
nathan

#6Bruce Momjian
bruce@momjian.us
In reply to: Nathan Bossart (#5)
Re: add list of major features to the v19 release notes

On Tue, Jul 28, 2026 at 10:39:19AM -0500, Nathan Bossart wrote:

On Thu, Jul 02, 2026 at 09:36:46AM -0500, Nathan Bossart wrote:

Subject: [PATCH v2 1/1] Add list of major features to the v19 release notes.

Barring more feedback, I'd like to proceed with this patch sooner than
later.

Sure, I am usually not involved with the major feature list.

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

Do not let urgent matters crowd out time for investment in the future.

#7Nathan Bossart
nathandbossart@gmail.com
In reply to: Bruce Momjian (#6)
Re: add list of major features to the v19 release notes

Committed.

--
nathan

#8Jonathan S. Katz
jkatz@postgresql.org
In reply to: Nathan Bossart (#7)
Re: add list of major features to the v19 release notes

On 7/31/26 3:01 PM, Nathan Bossart wrote:

Committed.

Thanks for drafting this!

I think there's a notable omission, specifically around the `ALTER TABLE
... MERGE/SPLIT PARTITIONS` as this has historically been a challenging
operation for folks. I added proposed copy here (which is mostly a
rewording of the release note).

This has been up for awhile, so I don't want to suggest removing items
for this list. That said, I'd like to suggest a few
listing/wording/ordering tweaks, primarily to tighten up a few of the
explanations and align with the style from previous release notes.

Thanks,

Jonathan

Attachments:

v2-doc-release-19-major.difftext/plain; charset=UTF-8; name=v2-doc-release-19-major.diffDownload+34-30
#9Andrew Dunstan
andrew@dunslane.net
In reply to: Jonathan S. Katz (#8)
Re: add list of major features to the v19 release notes

On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:

On 7/31/26 3:01 PM, Nathan Bossart wrote:

Committed.

Thanks for drafting this!

I think there's a notable omission, specifically around the `ALTER
TABLE ... MERGE/SPLIT PARTITIONS` as this has historically been a
challenging operation for folks. I added proposed copy here (which is
mostly a rewording of the release note).

This has been up for awhile, so I don't want to suggest removing items
for this list. That said, I'd like to suggest a few
listing/wording/ordering tweaks, primarily to tighten up a few of the
explanations and align with the style from previous release notes.

I don't know how the ordering was arrived at. I think we should lead
with blockbuster items. Everyone will have their own opinion, but in my
mind the blockbuster items are REPACK and pg_plan_advice.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

#10Nathan Bossart
nathandbossart@gmail.com
In reply to: Andrew Dunstan (#9)
Re: add list of major features to the v19 release notes

On Sat, Aug 22, 2026 at 05:50:56PM -0400, Andrew Dunstan wrote:

On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:

This has been up for awhile, so I don't want to suggest removing items
for this list. That said, I'd like to suggest a few
listing/wording/ordering tweaks, primarily to tighten up a few of the
explanations and align with the style from previous release notes.

I don't know how the ordering was arrived at. I think we should lead with
blockbuster items. Everyone will have their own opinion, but in my mind the
blockbuster items are REPACK and pg_plan_advice.

There wasn't a whole lot of science around the ordering. We did
intentionally put the catch-all performance item at the end, but that was
about the extent of conscious thought about it.

Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.

--
nathan

#11Jonathan S. Katz
jkatz@postgresql.org
In reply to: Nathan Bossart (#10)
Re: add list of major features to the v19 release notes

On 8/25/26 10:30 AM, Nathan Bossart wrote:

On Sat, Aug 22, 2026 at 05:50:56PM -0400, Andrew Dunstan wrote:

On 2026-08-22 Sa 3:56 PM, Jonathan S. Katz wrote:

This has been up for awhile, so I don't want to suggest removing items
for this list. That said, I'd like to suggest a few
listing/wording/ordering tweaks, primarily to tighten up a few of the
explanations and align with the style from previous release notes.

I don't know how the ordering was arrived at. I think we should lead with
blockbuster items. Everyone will have their own opinion, but in my mind the
blockbuster items are REPACK and pg_plan_advice.

"Blockbuster" means different things to different people - when I
propose ordering, I'm typically looking for an optimization around how
many users does the change impact and how resounding that impact is.

That said, in the proposed patch I did shuffle the order around that
algorithm - if needed I'm happy to detail the thinking more, but I like
to be careful around this given people have put a lot of work and effort
into all the patches and did work specifically because they want to make
things better/easier for users.

There wasn't a whole lot of science around the ordering. We did
intentionally put the catch-all performance item at the end, but that was
about the extent of conscious thought about it.

Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.

Thanks; happy to make additional tweaks if need be.

Thanks,

Jonathan

#12Nathan Bossart
nathandbossart@gmail.com
In reply to: Jonathan S. Katz (#11)
Re: add list of major features to the v19 release notes

On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:

On 8/25/26 10:30 AM, Nathan Bossart wrote:

Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.

Thanks; happy to make additional tweaks if need be.

A number of things have been (or are being) reverted, so this will need to
be reworked. We might want to bump one or two features into the list while
we're at it.

--
nathan

#13Bruce Momjian
bruce@momjian.us
In reply to: Nathan Bossart (#12)
Re: add list of major features to the v19 release notes

On Tue, Sep 15, 2026 at 07:05:12AM -0500, Nathan Bossart wrote:

On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:

On 8/25/26 10:30 AM, Nathan Bossart wrote:

Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.

Thanks; happy to make additional tweaks if need be.

A number of things have been (or are being) reverted, so this will need to
be reworked. We might want to bump one or two features into the list while
we're at it.

FYI, I have not modified that list since I am not the owner of that part
of the doc. However, I didn't see anything that needs removal so I
assume others have updated it.

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

Do not let urgent matters crowd out time for investment in the future.

#14Nathan Bossart
nathandbossart@gmail.com
In reply to: Bruce Momjian (#13)
Re: add list of major features to the v19 release notes

On Tue, Sep 15, 2026 at 09:24:08AM -0400, Bruce Momjian wrote:

On Tue, Sep 15, 2026 at 07:05:12AM -0500, Nathan Bossart wrote:

On Tue, Aug 25, 2026 at 09:52:32AM -0600, Jonathan S. Katz wrote:

On 8/25/26 10:30 AM, Nathan Bossart wrote:

Jonathan's proposed changes seem fine to me at a glance. I'll let that
marinate on the lists a bit more before applying.

Thanks; happy to make additional tweaks if need be.

A number of things have been (or are being) reverted, so this will need to
be reworked. We might want to bump one or two features into the list while
we're at it.

FYI, I have not modified that list since I am not the owner of that part
of the doc. However, I didn't see anything that needs removal so I
assume others have updated it.

I think the only remaining item that is pending removal is the online
checksums one, and I'm willing to bet that Daniel will take care of that.
What needs rework is Jonathan's patch.

--
nathan

#15Daniel Gustafsson
daniel@yesql.se
In reply to: Nathan Bossart (#14)
Re: add list of major features to the v19 release notes

On 15 Sep 2026, at 16:38, Nathan Bossart <nathandbossart@gmail.com> wrote:

I think the only remaining item that is pending removal is the online
checksums one, and I'm willing to bet that Daniel will take care of that.

I did.

--
Daniel Gustafsson

#16Jonathan S. Katz
jkatz@postgresql.org
In reply to: Daniel Gustafsson (#15)
Re: add list of major features to the v19 release notes

On 9/16/26 5:31 PM, Daniel Gustafsson wrote:

On 15 Sep 2026, at 16:38, Nathan Bossart <nathandbossart@gmail.com> wrote:

I think the only remaining item that is pending removal is the online
checksums one, and I'm willing to bet that Daniel will take care of that.

I did.

Here's v3 of the major features list. This merges in the changes from
the v2 proposal upthread with the other changes to the list over the
past several weeks.

Thanks,

Jonathan

Attachments:

v3-doc-release-19-major.difftext/plain; charset=UTF-8; name=v3-doc-release-19-major.diffDownload+26-28
#17Nathan Bossart
nathandbossart@gmail.com
In reply to: Jonathan S. Katz (#16)
Re: add list of major features to the v19 release notes

On Fri, Sep 18, 2026 at 07:23:11PM +0800, Jonathan S. Katz wrote:

Here's v3 of the major features list. This merges in the changes from the v2
proposal upthread with the other changes to the list over the past several
weeks.

Thanks for the patch.

+ New <link linkend="sql-repack"><command>REPACK</command></link> command

nit: extra space before "command"

+      that reclaims disk space and reorganizes table contents, which can help
+      increase query performance. <literal>REPACK CONCURRENTLY</literal>
+      allows repacking without blocking reads and writes to the table.

s/which can help increase/which can improve

+      Logical replication and can now be enabled without a server restart when
+      <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>.

nit: extra "and"

+ Support <quote>read-your-writes</quote> on standbys with the new

Hm. Can we be more descriptive here? Maybe something like "Support for
read-your-writes query patterns on standbys via the new..."

+ <link linkend="sql-wait"><command>WAIT FOR</command></link> command.

Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
"WAIT" and not "WAIT FOR".

+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.

IMHO this makes it sound like users will be able to choose the priority of
each individual table, when we actually are just giving them a handful of
coarse controls. I think we ought to emphasize the scoring system instead.
In theory, most users shouldn't need to adjust anything and the
prioritization will "Just Work" for them.

--
nathan

#18Jonathan S. Katz
jkatz@postgresql.org
In reply to: Nathan Bossart (#17)
Re: add list of major features to the v19 release notes

On 9/18/26 11:52 AM, Nathan Bossart wrote:

Thanks for the patch.

Thanks for the review - sorry for the delay, for some reason this didn't
hit my inbox.

nit: extra space before "command"

Fixed.

s/which can help increase/which can improve

Accepted.

nit: extra "and"

Fixed.

Hm. Can we be more descriptive here? Maybe something like "Support for
read-your-writes query patterns on standbys via the new..."

Doing some research, it seems the most common word is "consistency". I
opted for that. LMK what you think.

Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
"WAIT" and not "WAIT FOR".

Ack; I'll refrain from bikeshedding. Adjusted.

+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.

IMHO this makes it sound like users will be able to choose the priority of
each individual table, when we actually are just giving them a handful of
coarse controls. I think we ought to emphasize the scoring system instead.
In theory, most users shouldn't need to adjust anything and the
prioritization will "Just Work" for them.

Ack; I took a read of the docs and saw we were referring to it as
autovacuuming prioritization, so tried:

+ <link linkend="autovacuum-priority">autovacuuming prioritization</link>
+ through a new scoring system.

if you think that makes sense based on that. Patch attached.

Thanks,

Jonathan

Attachments:

v4-doc-release-19-major.difftext/plain; charset=UTF-8; name=v4-doc-release-19-major.diffDownload+28-28
#19Florents Tselai
florents.tselai@gmail.com
In reply to: Jonathan S. Katz (#18)
Re: add list of major features to the v19 release notes

On 23 Sep 2026, at 5:51 PM, Jonathan S. Katz <jkatz@postgresql.org> wrote:

On 9/18/26 11:52 AM, Nathan Bossart wrote:

Thanks for the patch.

Thanks for the review - sorry for the delay, for some reason this didn't hit my inbox.

nit: extra space before "command"

Fixed.

s/which can help increase/which can improve

Accepted.

nit: extra "and"

Fixed.

Hm. Can we be more descriptive here? Maybe something like "Support for
read-your-writes query patterns on standbys via the new..."

Doing some research, it seems the most common word is "consistency". I opted for that. LMK what you think.

Per commits 1a562a2661b and e527bf17d04, I think we're just calling it
"WAIT" and not "WAIT FOR".

Ack; I'll refrain from bikeshedding. Adjusted.

+ <link linkend="autovacuum-priority">user-defined prioritization of autovacuuming</link>.

IMHO this makes it sound like users will be able to choose the priority of
each individual table, when we actually are just giving them a handful of
coarse controls. I think we ought to emphasize the scoring system instead.
In theory, most users shouldn't need to adjust anything and the
prioritization will "Just Work" for them.

Ack; I took a read of the docs and saw we were referring to it as autovacuuming prioritization, so tried:

+ <link linkend="autovacuum-priority">autovacuuming prioritization</link>
+ through a new scoring system.

if you think that makes sense based on that. Patch attached.

Thanks,

Jonathan

<v4-doc-release-19-major.diff>

Hi,

Would it be worth mentioning the new jsonpath string methods in the release highlights? (My patch —> biased)

The overview currently focuses mostly on operational and performance improvements, and this could provide a useful application-developer-facing addition.

Its value is in how the methods compose: trimming whitespace, normalizing case, replacing text, and extracting string components directly within JSON path expressions.
This makes common JSON querying and data-cleaning tasks easier to express without moving those operations into surrounding SQL.
Also note that 18 itself was thin on JSON improvements it

Possible wording: “Expanded SQL/JSON path support with string methods for text normalization and extraction, enabling more expressive JSON queries.”

#20Nathan Bossart
nathandbossart@gmail.com
In reply to: Jonathan S. Katz (#18)
Re: add list of major features to the v19 release notes

On Wed, Sep 23, 2026 at 10:51:31AM -0400, Jonathan S. Katz wrote:

On 9/18/26 11:52 AM, Nathan Bossart wrote:

Thanks for the patch.

Thanks for the review - sorry for the delay, for some reason this didn't hit
my inbox.

No worries. Here's what I have after a little more copy-editing. I don't
think we should update the "AS OF" line; I think that's something Bruce
uses for the parts he manages.

--
nathan

Attachments:

v5-0001-update-list-of-major-features-for-v19.patchtext/plain; charset=us-asciiDownload+25-28
#21Jonathan S. Katz
jkatz@postgresql.org
In reply to: Nathan Bossart (#20)
#22Jonathan S. Katz
jkatz@postgresql.org
In reply to: Florents Tselai (#19)
#23Nathan Bossart
nathandbossart@gmail.com
In reply to: Jonathan S. Katz (#21)
#24Bruce Momjian
bruce@momjian.us
In reply to: Jonathan S. Katz (#18)
#25Jonathan S. Katz
jkatz@postgresql.org
In reply to: Bruce Momjian (#24)
#26Bruce Momjian
bruce@momjian.us
In reply to: Jonathan S. Katz (#25)