From: Bruce Momjian <bruce@momjian.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Subject: Re: First draft of PG 19 release notes
Date: Wed, 15 Apr 2026 15:34:17 -0400
Message-ID: <ad_oOUQloVs-3k30@momjian.us> (raw)
In-Reply-To: <ad_b0gS8GJMW_QXi@momjian.us>
References: <ad7ngXC125AvNqC2@momjian.us>
<CAApHDvrsyD3QKBO=dypNkyFzYOzQEbgy+xJLwn=y+h+bLSDd-g@mail.gmail.com>
<ad_b0gS8GJMW_QXi@momjian.us>
On Wed, Apr 15, 2026 at 02:41:22PM -0400, Bruce Momjian wrote:
> On Wed, Apr 15, 2026 at 02:29:49PM +1200, David Rowley wrote:
> > On Wed, 15 Apr 2026 at 13:19, Bruce Momjian <bruce@momjian.us> wrote:
> > > I have completed the first draft of the PG 19 release notes:
> > >
> > > https://www.postgresql.org/docs/devel/release-19.html
> >
> > Many thanks for your efforts here.
> >
> > "Improve performance of internal row formation (David Rowley)"
> >
> > It's really deformation, not formation. As far as I know, nothing in
> > v19 sped up tuple formation.
>
> Changed to:
>
> Improve performance of internal row deformation (David Rowley)
> --
> Thanks.
>
> > I also think Nathan's work on autovacuum table prioritisation
> > (d7965d65f) is worth a mention. There were concerns there that it
> > might cause trouble for people who (for some reason) get best results
> > from the previous pg_class-ordered priority. Having something in the
> > notes about this might help direct someone towards why they're seeing
> > autovacuum behave differently after upgrading.
>
> Yikes, so I collected commits on March 26, but when I went to add new
> commits, I used March 27 as the start date, and missed all the late
> March 26 commits. I should have started on March 26 to get
> later-in-the-day commits!
>
> I went back and looked at the commits I missed and the one you pointed
> out is the only relevant one, so that is good.
>
> Applied patch attached.
Oops, patch _now_ attached.
--
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.
commit 23ec74c8a85
Author: Bruce Momjian <bruce@momjian.us>
Date: Wed Apr 15 14:42:57 2026 -0400
doc PG 19 relnotes: add missing March 16 autovacuum score item
Also fix "deformed" tuples.
Reported-by: David Rowley
Backpatch-through: CAApHDvrsyD3QKBO=dypNkyFzYOzQEbgy+xJLwn=y+h+bLSDd-g@mail.gmail.com
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 28ca12da3c8..bae5008a4ab 100644--- a/doc/src/sgml/release-19.sgml+++ b/doc/src/sgml/release-19.sgml@@ -733,7 +733,7 @@ Author: David Rowley <drowley@postgresql.org>
<listitem>
<para>
-Improve performance of internal row formation (David Rowley)+Improve performance of internal row deformation (David Rowley)
<ulink url="&commit_baseurl;c456e3911">§</ulink>
</para>
</listitem>
@@ -1216,6 +1216,23 @@ Previously the checksum status could only be set at initialization and changed o
</para>
</listitem>
+<!--+Author: Nathan Bossart <nathan@postgresql.org>+2026-03-27 [d7965d65f] Add rudimentary table prioritization to autovacuum.+-->++<listitem>+<para>+Add scoring system to control the order that tables are autovacuumed (Nathan Bossart)+<ulink url="&commit_baseurl;d7965d65f">§</ulink>+</para>++<para>+The new server variables are autovacuum_freeze_score_weight, autovacuum_multixact_freeze_score_weight, autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight, and+autovacuum_analyze_score_weight.+</para>+</listitem>+
<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2026-03-18 [4f433025f] ssl: Serverside SNI support for libpq
Attachments:
[text/plain] diff (1.6K, ../ad_oOUQloVs-3k30@momjian.us/2-diff)
download | inline diff:
commit 23ec74c8a85
Author: Bruce Momjian <bruce@momjian.us>
Date: Wed Apr 15 14:42:57 2026 -0400
doc PG 19 relnotes: add missing March 16 autovacuum score item
Also fix "deformed" tuples.
Reported-by: David Rowley
Backpatch-through: CAApHDvrsyD3QKBO=dypNkyFzYOzQEbgy+xJLwn=y+h+bLSDd-g@mail.gmail.com
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgmlindex 28ca12da3c8..bae5008a4ab 100644--- a/doc/src/sgml/release-19.sgml+++ b/doc/src/sgml/release-19.sgml@@ -733,7 +733,7 @@ Author: David Rowley <drowley@postgresql.org>
<listitem>
<para>
-Improve performance of internal row formation (David Rowley)+Improve performance of internal row deformation (David Rowley)
<ulink url="&commit_baseurl;c456e3911">§</ulink>
</para>
</listitem>
@@ -1216,6 +1216,23 @@ Previously the checksum status could only be set at initialization and changed o
</para>
</listitem>
+<!--+Author: Nathan Bossart <nathan@postgresql.org>+2026-03-27 [d7965d65f] Add rudimentary table prioritization to autovacuum.+-->++<listitem>+<para>+Add scoring system to control the order that tables are autovacuumed (Nathan Bossart)+<ulink url="&commit_baseurl;d7965d65f">§</ulink>+</para>++<para>+The new server variables are autovacuum_freeze_score_weight, autovacuum_multixact_freeze_score_weight, autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight, and+autovacuum_analyze_score_weight.+</para>+</listitem>+
<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2026-03-18 [4f433025f] ssl: Serverside SNI support for libpq
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: bruce@momjian.us, dgrowleyml@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: First draft of PG 19 release notes
In-Reply-To: <ad_oOUQloVs-3k30@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox