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 1x7asu-00000000VHv-1Lnf for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Sep 2026 15:52:20 +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 1x7ast-000000023sD-2e1u for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Sep 2026 15:52:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7ast-000000023s5-1SDT for pgsql-hackers@lists.postgresql.org; Fri, 18 Sep 2026 15:52:19 +0000 Received: from mail-qk2-x0f.google.com ([2607:f8b0:4864:34::f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x7asq-000000003Ds-04Xd for pgsql-hackers@postgresql.org; Fri, 18 Sep 2026 15:52:18 +0000 Received: by mail-qk2-x0f.google.com with SMTP id d75a77b69052e-52fb76ef1d0so8147541cf.0 for ; Fri, 18 Sep 2026 08:52:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1789746735; x=1790351535; 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=NoZ4SQj2EiHMOtj2eHKqv1UgTo1YWgzNVoCMapETQ+Y=; b=DmbXmVSpQTVmH+LZi2Bin1qpCF17300rdHHPHn4/csaQwuQo6qiAW4ASO3HVch2qh4 I1sCCzZHJijypyEvHYd0cTZbV+ZMUHbkmFS56DAGdVt5N9KHylhYWYG+mTUP65hRHJpe 5lKpK2Cv9nNgyJWfwDvzyMo5rmlyh/z4qaYfZ8XArjOILwbcRWmgiRWJQPzlR1p2pAqo SfHDVipK9xH4UyZ6ct4Wogl0O3/8wEk7KQE1Lv7yUH6NmnWkL4/wOKXFLQWXm2PT43Nf AxibLBeqn2jhRo7cGz1yXjdupa+mq/BbUcWSoEdfxw2/31KeZIwTlmopgHzizu/NPyCy 3XEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1789746735; x=1790351535; 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=NoZ4SQj2EiHMOtj2eHKqv1UgTo1YWgzNVoCMapETQ+Y=; b=cXK+k6wKZ/frfdKj/BK9yqDWA5PtpBHzr67nZstE8skwHPhaCWsPC6H6Rxq8kQ78Uu 0I/fQerbPuTJ2kTksFj7O7a7FZaULyrv00zLGkZkW2PFiwy/LcPSNmF4fE67+4uVLaIz sIR8Faltfx94jrmHAwz/iEe2ksPKVcUqWi+n3YEr9ksExhthcYT9VQOszjbQg2uEENOt /g5pABUhKyd/mI3YjPvx5weqZOl22cctKWWH6EpQChRiDwM1o6+TvcCXP3L1PVuT5rwn LRw5uXQN/R6z1DHuBdXIHVvfspPC6EyPOXvnGAvZsYzO9fD2NmlLn1Y4b1AP3KmxjFbV uC6w== X-Forwarded-Encrypted: i=1; AKwUvBxtcq24FicdU5eQRB3p9MdohpP11IMFAdbQ9fFb9Ncm1AgXq+Ihygokbel/WIF0GK/tCE84x0j9C7vfpXGC@postgresql.org X-Gm-Message-State: AFuF++lUxmtOUZELhxcu3EXccERFo0/dsxyQcKE5JrNtM7iXbk9cOm0p RqLJN2MBOQYck6+6VImno+WNp3uBESYsbfrDYN5Sx4SdYGrjLh26XPAJ X-Gm-Gg: AYBFou3rO1RN8Pf7gS7exkSqCIcmlAR58kYlLxop288TSKhg6f2mSsL+dNgiNu4DJFM xoP8h+VcRwVF+XUrwkLwgdTSRkGtNiunu41/ce1AdF/rBFl5wdEGMXcCuaolZQy3rlSrns5OqKC PXm7AmYH3Ab9XIwYN57JsikLH7sHGK0cpYpKuMIItlP34Q/FO+u+xNrz1pz+OcMIVJ/40R0ETWp mVAbJVK0e0ROpyFlKHN9qG0yDskmV6xwlc1t3ZMIthyxy4GBzuQ6TPUfsFR7WbSTGO33rFu8y4z M6+3lLRBRKcRFKGTJ8ucXKBFJ6uJwRhznzTj8r8kVbhihPy9GcwYhiUr2Y0ulLTHEhOGBeIkcVl ZjghLXB2RR+RCOWd+tNgwbHE6i8O0rmsmHsL1SpmfRolbJGkma3ics9mca/WAxswft+agQ6C4jw xjniLIGrDce/giQ7S6xV5c0c3RwVZcEd/NwAmz5r379bgrU69KhK2VP7e8JP0zyLxDPTu4zlZTL DKx31NApIwppEhDadS+X68F/JPxpQtbxjlSO4wtjhWv5uPXzcSOV7R8UjaR5jozE3JFzWnqFc7m 1ivm9DLYwqcd24M0ZNIC5aiABA== X-Received: by 2002:a05:622a:3cf:b0:532:9add:50b2 with SMTP id d75a77b69052e-5329e3dca9cmr47511861cf.66.1789746734894; Fri, 18 Sep 2026 08:52:14 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-532a1a0a160sm16857861cf.27.2026.09.18.08.52.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Sep 2026 08:52:14 -0700 (PDT) Date: Fri, 18 Sep 2026 10:52:12 -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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0d7d83de-30c2-470e-ad60-84d127b6165a@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 REPACK command nit: extra space before "command" > + that reclaims disk space and reorganizes table contents, which can help > + increase query performance. REPACK CONCURRENTLY > + 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 > + is set to replica. nit: extra "and" > + Support read-your-writes 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..." > + WAIT FOR command. Per commits 1a562a2661b and e527bf17d04, I think we're just calling it "WAIT" and not "WAIT FOR". > + user-defined prioritization of autovacuuming. 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