Re: add list of major features to the v19 release notes

From: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, Bruce Momjian <bruce(at)momjian(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Michael Banck <mbanck(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add list of major features to the v19 release notes
Date: 2026-09-23 15:20:05
Message-ID: 3897ED91-7CFE-43CA-BEA3-0C4B0B2E900C@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 23 Sep 2026, at 5:51 PM, Jonathan S. Katz <jkatz(at)postgresql(dot)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.”

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-09-23 16:05:20 Re: Persist slot invalidations before publishing them
Previous Message Greg Burd 2026-09-23 15:17:22 Re: [PATCH] unrecognized win32 error 448 (ERROR_UNTRUSTED_MOUNT_POINT) breaks tablespaces on Win11 26200