Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x9R52-00000001zx3-0NcU for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Sep 2026 17:48:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x9R51-00000006r4I-1dlH for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Sep 2026 17:48:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x9R51-00000006r49-0Lht for pgsql-hackers@lists.postgresql.org; Wed, 23 Sep 2026 17:48:27 +0000 Received: from mail-qk2-x0f.google.com ([2607:f8b0:4864:34::f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x9R4y-00000000v2k-3TnJ for pgsql-hackers@postgresql.org; Wed, 23 Sep 2026 17:48:26 +0000 Received: by mail-qk2-x0f.google.com with SMTP id d75a77b69052e-530d0d5ae11so12231921cf.0 for ; Wed, 23 Sep 2026 10:48:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1790185702; x=1790790502; darn=postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=Uh0Y7myTCWihaQpMdzHh/sisLkD7wW7xF9HZogpgFG4=; b=TCz528XhXY9gik28vtZsOQuUzvXxhxppoFNfmrvb424aRXW4GmUBqSQy1oVGCOzlPv hUoM6+44awW8UWut2QUsfrXCwzt2xSxngbGStxLpnnswRaA2eNmRG8700nhl6SagfI36 /Cxn0Q2UjGIcmWPhWVdEbmmZVavQpZU/6kX9gKsxLwSxpfU28G4S20R9KVAhKBkUt6lx QFWRrgTqtvb5zHL5YWiSOZTuoMHYlGo54mBrbgQ6Ovw/nWGW9llVffdHunl6BWWQMENZ Ks8h5bejcdG1VBljAFChIEjAR6TzFutmQQMrW0MdcP+CUmU+3jemLrC4fYhDSKutXxzM fziQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1790185702; x=1790790502; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=Uh0Y7myTCWihaQpMdzHh/sisLkD7wW7xF9HZogpgFG4=; b=r5BgTl51UdpoIYFBeugODaaGTDfVkf4jFdzgZn7NyjO4rw4auE398QHJsFv2nQjpE5 7T4kAlS8fd1LhecKh62Q8AnERRiUovwD0hs9qcWJmDm3VeLpid0MTGDOS1mIbuBcJWCl dxtPxpBa1ZVSkdC0b23WSlM0XtjiTc5uT/RpMw4yrnApW6Xlpns1s/nQMUlA33sKTJ19 6wczPBrgWrA69azMEZExGw5GtTLc9tpVrrVp2vXAmaG8c4ZjsSIlhSV4FMEftf42LxxH ZlFSG29R5cmzeVV7FcVrTASssdHFVvE2sIRAp4Ig7xARTDq2sLlGdP1tBJ9ITxe8W58Y SRaQ== X-Forwarded-Encrypted: i=1; AKwUvBzBBEKnHajnVTuuIqZChlKmbxYnbQxMV3aSZlIiBLXiugX9jldmBJRc+jFPn/qV8rCA8Hn/AsC/3B/ohgsn@postgresql.org X-Gm-Message-State: AFuF++m1L5hpZ07kFII1xKMsMV2i3GNvXo3eM1zHTDpODv8x7RfPwGxE 9cgodGooskK9rczfP7JI4lqOYv+LkTbModjQezuHEsDNKjklHJmd0D8B X-Gm-Gg: AYBFou3Hha/6vPvlalV8w0Tar3p9U7RbjaW44MHuDN2CQqDVXofHG5SoT5tkYrHSTcW OWDIlkCRiM8a4t2NQUYjw+/jG5CLUM7ujI+oGny7i7wz0hTdL1z2ZGNuViBGT+BrdmYZUdH5jNE h25UzHBDwMsp8ztmAydX+a/PX1Jsqdc/QCqMae21M7bI2fKJYrNeJ2NC45v8nZTMg0AMYZ9knJF vszjJoE8xzn6pzn5Pu9TEvuw0DcULcN2PxT+aSN0UlUbWfShUhoaInPlfvNg4ngnYeSTgs/8rBy /ox7gQqa6XhHQmk1VdcBDaxz+8s1rddFwF1ULfdS8/UB2+wVvoa1kqXCtvwa1dk3+R9yCI9ppsC Nka+eV9TBIs8Z5ZITxEN6ZLICRXqeVVD1PTVbHvBa15yffdIRFkNtIv6F3O52NcE/Yt0NaaYcm5 QB2rt6OtsX1Z7kmJBZBMKInqUYeMGfz0fpEtDHvSgdIVCEX0DeKRPoHuws4keTd2rkgn9jeqKit hdl6xfTOy2xgg0CsmvKCKQLOKBnUUJgeux11FJQj3GqrE8MefODf/OgeFGvc/jPI0saXI2/qayp kJ0nmJ72MIWuF6gQNVimdhkeylkTuiYWwtY9 X-Received: by 2002:a05:620a:6502:b0:939:6dea:4f1a with SMTP id af79cd13be357-93c251c9b0emr517998585a.48.1790185702163; Wed, 23 Sep 2026 10:48:22 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id af79cd13be357-93c33e6e728sm2914785a.36.2026.09.23.10.48.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Sep 2026 10:48:21 -0700 (PDT) Date: Wed, 23 Sep 2026 12:48:19 -0500 From: Nathan Bossart To: "Jonathan S. Katz" Cc: Daniel Gustafsson , Bruce Momjian , Andrew Dunstan , Michael Banck , PostgreSQL Hackers Subject: Re: add list of major features to the v19 release notes Message-ID: References: <0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org> <41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="jp9muDKfqJEOU8PG" Content-Disposition: inline In-Reply-To: <41ef3063-25fe-43a4-b8d9-cd715593665f@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --jp9muDKfqJEOU8PG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --jp9muDKfqJEOU8PG Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v5-0001-update-list-of-major-features-for-v19.patch From 851be0cae73ddc696ae06149e37eb0b77f1a0e3f Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Wed, 23 Sep 2026 12:47:25 -0500 Subject: [PATCH v5 1/1] update list of major features for v19 --- doc/src/sgml/release-19.sgml | 52 +++++++++++++++++------------------- 1 file changed, 25 insertions(+), 27 deletions(-) diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml index 0266d6a98e0..9f81f319595 100644 --- a/doc/src/sgml/release-19.sgml +++ b/doc/src/sgml/release-19.sgml @@ -20,58 +20,56 @@ - A new REPACK command - that reclaims disk space and reorganizes table contents, combining the - functionality of the existing VACUUM FULL and - CLUSTER commands. Its CONCURRENTLY - option allows repacking without blocking reads and writes to the table. + New command that reclaims disk space and + reorganizes table contents, which can improve query performance. + REPACK (CONCURRENTLY) allows repacking without + blocking reads and writes to the table. - Logical replication now - replicates sequence values - and can be enabled without a server restart when - is set to replica. + extension for controlling query planner + decisions and extension that applies plan + advice automatically based on the query. - Autovacuum can now use - parallel worker processes - to vacuum a table's indexes, and a - new scoring system prioritizes - the tables that most need vacuuming or analyzing. + Better performance in many areas, including automatic scaling of the + number of I/O worker processes, quicker foreign-key checks, and further + planning and execution optimizations. - A new WAIT - command that waits until a standby has replayed changes up to a chosen - point, thereby supporting read-your-writes query patterns - on standbys. + Logical replication can now be enabled without a server restart when + is set to replica. - A new - pg_plan_advice - extension for stabilizing and controlling the query planner's decisions, - and a companion - pg_stash_advice - extension that applies this advice automatically based on the query. + Logical replication of + sequence values. - Better performance in many areas, including automatic scaling of the - number of I/O worker processes, quicker foreign-key checks, and further - planning and execution optimizations. + Support for read-your-writes consistency on standbys via + the new command. + + + + + + Parallel autovacuum of table indexes + and + autovacuum prioritization + through a new scoring system. -- 2.55.0 --jp9muDKfqJEOU8PG--