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 1mSa1e-0006BP-HR for pgsql-advocacy@arkaria.postgresql.org; Tue, 21 Sep 2021 07:17:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSa1c-00030z-Mr for pgsql-advocacy@arkaria.postgresql.org; Tue, 21 Sep 2021 07:17:08 +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 1mSa1c-00030r-Go for pgsql-advocacy@lists.postgresql.org; Tue, 21 Sep 2021 07:17:08 +0000 Received: from mail-wr1-x42a.google.com ([2a00:1450:4864:20::42a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mSa1V-0005M5-Op for pgsql-advocacy@lists.postgresql.org; Tue, 21 Sep 2021 07:17:07 +0000 Received: by mail-wr1-x42a.google.com with SMTP id w17so28109931wrv.10 for ; Tue, 21 Sep 2021 00:17:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=KrQfLFr/CQkHtB0tFzObn0KkI3XEtg+N6ICm91gCzQc=; b=LmadYHRRoBFH6BZ0H78nBZGlCuN/OEAs5WusT+ZmmoJ7gx0FWzdbqzFZhqXCv66ZKp ZFPFPKxchKko1ypBBSRIgIyRvbofc4b6qO9rli//4AJ6/+7wIzip9Q+CJ9a/JhXMiqfy 1kXLf/NtgmVVb3Kio7cT2IS3Jfzok9aepSz26/yLU6Y695kYjjCHyHa+npRGBR+Rx+mY O+5843t/5k5iNtvVVpvZLhmHkMVDDL5Birapxlc308pQVxbSBJasQ3MKdaB+zSa9iwj3 g76MRaEzfHaq+u1H4SjfRGaNp+G3LrNGCCFvIqH+3xcFYA7Q1506rrFMxAs6MBlzfpKA 9Vjg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=KrQfLFr/CQkHtB0tFzObn0KkI3XEtg+N6ICm91gCzQc=; b=f9h9eHTJQKvYFFeztDzjadu8EqfvZQsCGIvtu7EunhekaJtJsB2eRadrKm7g5OPm89 ibF0LAFXMC6i+eJA3uHLmo+saMWroIv1jSsHtoKZLelzuxhwUnokgUglRrcoHR3M6JGy eNAMfIjsIfQB5OApbrsic6bvXHSUkNvor0RLtrjKqUJy68TcdpM85nvZ0Gmxk97CmLen mfONgFqP/f8kVTzgM/mdc2EEskovOsNHdyaBksrpIqB4kQkZv6M9eL39f5lPeQnPWS1y bBzMjFWaRhh9TSgXvUAqhFpC3ldylRSBoWJqPjMFek/hyBW20J9EwS3MTbOfl4PFZQOH kZEA== X-Gm-Message-State: AOAM5337SpeZkiIjIdigIRM+ouRA0Gvtd+UzngGocanLiIINE7UUYUur bEoL+RNI2XMHYWI6boJK6Vn/0g== X-Google-Smtp-Source: ABdhPJyHTNe43HBW7MTQGD4uV+9ygDtYUBu6J1Ia4vHIi7o7gsOkGxZnq6d7pUustp+J4nUlOY+4oQ== X-Received: by 2002:adf:ef07:: with SMTP id e7mr33295572wro.56.1632208619879; Tue, 21 Sep 2021 00:16:59 -0700 (PDT) Received: from localhost.localdomain (dynamic-dz4sqfiy671l76fsd-pd01.res.v6.highway.a1.net. [2001:871:5c:1cb:3dde:c914:eb68:406d]) by smtp.gmail.com with ESMTPSA id c7sm1922605wmq.13.2021.09.21.00.16.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 21 Sep 2021 00:16:59 -0700 (PDT) Message-ID: <24a6b47c56f1f851ea673fc983d771f50150fd06.camel@cybertec.at> Subject: Re: PostgreSQL 14 press release draft From: Laurenz Albe To: "Jonathan S. Katz" , PostgreSQL Advocacy Date: Tue, 21 Sep 2021 09:16:58 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-1.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2021-09-20 at 22:19 -0400, Jonathan S. Katz wrote: > The [extended systems](https://www.postgresql.org/docs/14/planner-stats.html#PLANNER-STATS-EXTENDED) > includes many improvements in PostgreSQL 14, including the ability to apply > extend statistics on expressions. Additionally, > [window functions](https://www.postgresql.org/docs/14/functions-window.html) can > now benefit from incremental sorts, a feature that was introduced in > [PostgreSQL 13](https://www.postgresql.org/about/news/postgresql-13-released-2077/). "The extended systems" sounds weird to me, and the link points to extended statistics. Did you mean to say "Extended statistics include many ..."? But then the repetition jars. Perhaps: [Extended statistics](https://www.postgresql.org/docs/14/planner-stats.html#PLANNER-STATS-EXTENDED) can be used for expressions in PostgreSQL v14. Additionally, [window functions](https://www.postgresql.org/docs/14/functions-window.html) can now benefit from incremental sorts, a feature that was introduced in [PostgreSQL 13](https://www.postgresql.org/about/news/postgresql-13-released-2077/). Yours, Laurenz Albe