agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Nathan Bossart <nathandbossart@gmail.com>
To: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Michael Banck <mbanck@gmx.net>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: add list of major features to the v19 release notes
Date: Fri, 18 Sep 2026 10:52:12 -0500
Message-ID: <aq1eLOKSnS4Y-xDo@nathan> (raw)
In-Reply-To: <0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org>
References: <amzxHLIo5tAysXE2@nathan>
<e2324238-abec-4026-bd44-9b3e6c70bd49@postgresql.org>
<a796f7d5-1ce7-4f64-add4-bad40d7fc714@dunslane.net>
<ao2m-rfWTCtHhxCs@nathan>
<ce01d8e1-b653-4c04-91d7-54163f706795@postgresql.org>
<aqk0eJEDswnROyAm@nathan>
<aqlG-CUYpCgfhA29@momjian.us>
<aqlYgQ8vl0E2TyjZ@nathan>
<D254A4C7-5493-49DD-BF9C-CC865A838912@yesql.se>
<0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org>
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
view thread (1209+ messages)
Message-ID: <aq1eLOKSnS4Y-xDo@nathan>
Permalink: ../aq1eLOKSnS4Y-xDo@nathan/
Also on: postgresql.org/message-id/aq1eLOKSnS4Y-xDo@nathan
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: nathandbossart@gmail.com, jkatz@postgresql.org, daniel@yesql.se, bruce@momjian.us, andrew@dunslane.net, mbanck@gmx.net
Subject: Re: add list of major features to the v19 release notes
In-Reply-To: <aq1eLOKSnS4Y-xDo@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox