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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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+blsd...@mail.gmail.com diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml index 28ca12da3c8..bae5008a4ab 100644 --- a/doc/src/sgml/release-19.sgml +++ b/doc/src/sgml/release-19.sgml @@ -733,7 +733,7 @@ Author: David Rowley <[email protected]> <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 <[email protected]> +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 <[email protected]> 2026-03-18 [4f433025f] ssl: Serverside SNI support for libpq
