Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lspbC-0004aS-Ct for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jun 2021 16:38:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lspbB-0005yM-8i for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jun 2021 16:38:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lspbA-0005y8-UM for pgsql-hackers@lists.postgresql.org; Mon, 14 Jun 2021 16:38:05 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lspb7-0002G9-M2 for pgsql-hackers@lists.postgresql.org; Mon, 14 Jun 2021 16:38:03 +0000 Received: by mail-il1-x133.google.com with SMTP id i12so3352118ila.13 for ; Mon, 14 Jun 2021 09:38:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=gnIADrsozYV0354QeAi8gklcw2sO0VE1O6CsNHk3A84=; b=e3jY7it4mABbM2IwhXGx1KdBdVi/+7bNzvQNat/h3WbKiw3xVlt31pxxcwoTX6R4GT BQakIUvpkgXH3tJ4UtbGXYBOCQyYAYJQHA2vASeDMt9cazQt10t5LgjI6b3MVJtUnW8W 3vL5O+RkLoXTL4TEmjItbm3zg4ss4hJI9iK2NYgt/XV5IZ+pYq24/JV3d5XRsUbHKsuN m7i3IO1eCZwb2JZFaN0DZEEcS3yoUh85Iiumjv44e+VJYLnkRPgayWgrjn/I2Ttft8Wi 9d2qcFwEe68rPWYz/kpedZUUdZ2kGW3MKyLJGnQtFJWmaWdeOqWGZ9Ozb8xErcjlV20D mHJw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=gnIADrsozYV0354QeAi8gklcw2sO0VE1O6CsNHk3A84=; b=hUtVuHVyUCfl7LPnh4uypldyEpvfsccXR3LZJfyKt/FKUX+QH7uWiXlsH4RbAtN0Pv GXMM9j7sdUsLka4Gq0McGf2I0Pw7ZUEO/cM4SfsakI9VHla/tOTYNrF+so4+KnmaSTy4 xlLblvXI1tlF9ofbET7hZ/dZIE2iPAinrcTwrw96eHZkNfRA6jokGBJXG407eERn4tIW aXpQw38mNLGewEepjlsN6unBR5c/DCV6VHtRge9gRG9ERgPaSDY1lKpQhLYZF5r39GO9 CIFI7ecJ5TDP9wl8PmK5mgeNnZsFEu4+gcmhurKbIfFqOoIxmWUVtDsrYHKQP29XQ0xA AbOg== X-Gm-Message-State: AOAM533HmOe4spkdsUO/vlTTx3OSmP86+nDPPTcQHTWlBSnxNWoU6dXF QqzrDs/evn+KCylOk9gMcURCdPp9KgJURQ== X-Google-Smtp-Source: ABdhPJyYmmkXDgwSxFsp6YH53tIaa+SJA9aFstp9d3bDMc/R8umJKedIYpIKUnABpH099T//wUYPQg== X-Received: by 2002:a05:6e02:1d18:: with SMTP id i24mr15239449ila.116.1623688679826; Mon, 14 Jun 2021 09:37:59 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id g3sm8831773iob.13.2021.06.14.09.37.59 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 14 Jun 2021 09:37:59 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 527FC80090D; Mon, 14 Jun 2021 11:37:58 -0500 (CDT) Date: Mon, 14 Jun 2021 11:37:58 -0500 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-hackers@lists.postgresql.org Subject: Re: PG 14 release notes, first draft Message-ID: <20210614163758.GG31772@telsasoft.com> References: <20210510060308.GC6088@momjian.us> <20210519143908.GU373@telsasoft.com> <20210612004425.GQ16435@telsasoft.com> <20210612034551.GU16435@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210612034551.GU16435@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 11, 2021 at 10:45:51PM -0500, Justin Pryzby wrote: > | Add Set Server Name Indication (SNI) for SSL connection packets (Peter Eisentraut) > Remove "Set" > > | Reduce the default value of vacuum_cost_page_miss from 10 milliseconds to 2 (Peter Geoghegan) > Peter mentioned that this should not say "milliseconds" (but maybe the page I'm > looking at is old). > > | Cause vacuum operations to be aggressive if the table is near xid or multixact wraparound (Masahiko Sawada, Peter Geoghegan) > Say "become aggressive" ? > > | Allow the arbitrary collations of partition boundary values (Tom Lane) > Remove "the" > > | Generate WAL invalidations message during command completion when using logical replication (Dilip Kumar, Tomas Vondra, Amit Kapila) > invalidation messages > > | Add support for infinity and -infinity values to the numeric data type (Tom Lane) > "-infinity" has markup but not "infinity" ? > > | Allow vacuum to deallocate space reserved by trailing unused heap line pointers (Matthias van de Meent, Peter Geoghegan) > say "reclaim space" ? Some more: | VACUUM now has a PROCESS_TOAST which can be set to false to disable TOAST processing, and vacuumdb has a --no-process-toast option. has a process_toast *option | Previously, if the object already exists, EXPLAIN would fail. already existed | Function pg_stat_reset_replication_slot() resets slot statistics. *The function. But maybe it should be omitted. | New options are read-only, primary, standby, and prefer-standby. *The new options | Allow reindexdb to change the tablespace of the new index (Michael Paquier) | This is done by specifying --tablespace. I think this should be merged with the corresponding server feature, like this one: |Add ability to skip vacuuming of TOAST tables (Nathan Bossart) |VACUUM now has a PROCESS_TOAST which can be set to false to disable TOAST processing, and vacuumdb has a --no-process-toast option. Or, the client-side option could be omitted. This is distinguished from vacuumdb --no-index-cleanup and --no-truncate, for which the server support was added in v12, and the client support was essentially an omision. | Add documentation for the factorial() function (Peter Eisentraut) | With the removal of the ! operator in this release, factorial() is the only built-in way to compute a factorial. Could be ommited or collapsed into the other item. I know Tom thinks that it's unnecesary to document changes to documentation. -- Justin