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.94.2) (envelope-from ) id 1s7YYj-006Bme-Fy for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 10:42:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7YYi-005s9H-Jk for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 10:42:00 +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.94.2) (envelope-from ) id 1s7YYi-005s99-9G for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 10:42:00 +0000 Received: from mail-yb1-f178.google.com ([209.85.219.178]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s7YYd-000Tz7-RP for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 10:41:58 +0000 Received: by mail-yb1-f178.google.com with SMTP id 3f1490d57ef6-df457d734abso744829276.0 for ; Thu, 16 May 2024 03:41:55 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715856115; x=1716460915; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=OVu3Vnx4Bq/GHBDjxWOhUjXBfXLqqaU/BjiG3zK7Fqo=; b=JbUCGZwoCp1WXaKiHwoUC7USuV8Gud0/sBtsOc4PHQKZgiYYamj3ib5CS1YUbpjicD A3NAj0foxrfnX1rpKQyg/uP0cDXV90ACC0jxY/PJh4liK+VgT2PopFLNPuUh2SqwDJrc If00GKyKICJ8+6cqHQeAO5kWJ+51DLaUaVV64wTWlLpLnnHtD5sWvtCih/ibWChC6n9L ntE30xGJpAZhCcr17VgafhhSJVJF/IlUIfaEJh27gPiEDrQz1D9CvVwVhZlj2udn6A6G i14kV9afn9U9xJRe5IIOZhdzhekKH8xPcR/FpAl4skCkcKKE/c6i4GW1+Dlmsm7N1Ik8 YtcA== X-Gm-Message-State: AOJu0Yx7mmDTmmZhOxbzPeNDlCtLM3Fj37JjDNNlW/K+pKaIHY7MyM31 pOw4yt+S8hNkEXk/W5fXc39Kclz1Ia7YCEfjBjRFM96UkoXAku042buE5lvqJSLi8UiJlsghxp/ fUrAY4hlSSpw72gGXMfJCJxG/auRMZSQ38QY/Bw== X-Google-Smtp-Source: AGHT+IFlcHwd0rMtGNQW58RVKX/ccGcgntQcTfMKLcxfc9iTf2q4tqf8mqhEcxDt8sdv/Qm07vgiuCTOlXoFxU7z2h4= X-Received: by 2002:a25:a568:0:b0:de5:5506:5213 with SMTP id 3f1490d57ef6-dee4f2f6c64mr16959028276.11.1715856114763; Thu, 16 May 2024 03:41:54 -0700 (PDT) MIME-Version: 1.0 References: <6d008414-3da4-4049-a585-0aa20da1bbce@postgresql.org> In-Reply-To: <6d008414-3da4-4049-a585-0aa20da1bbce@postgresql.org> From: Jelte Fennema-Nio Date: Thu, 16 May 2024 12:41:50 +0200 Message-ID: Subject: Re: PostgreSQL 17 Beta 1 release announcement draft To: "Jonathan S. Katz" Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 16 May 2024 at 03:45, Jonathan S. Katz wrote: > Attached is a copy of the PostgreSQL 17 Beta 1 release announcement > draft. I think we can quickly mention c4ab7da6061 in the COPY paragraph, in some benchmarks it improved perf by close to 2x. Something like this: "has improved performance in PostgreSQL 17 when the source encoding matches the destination encoding *and when sending large rows from server to client*" Also, I think it's a bit weird to put the current COPY paragraph under Developer Experience. I think if you want to keep it there instead of move it to the per section, we should put the line about IGNORE_ERROR first instead of the perf improvements. Now the IGNORE_ERROR addition seems more of an afterthought. s/IGNORE_ERROR/ON_ERROR I think it would be good to clarify if the following applies when upgrading from or to PostgreSQL 17: "Starting with PostgreSQL 17, you no longer need to drop logical replication slots when using pg_upgrade" Finally, I personally would have included a lot more links for the new items in this document. Some that would benefit from being a link imho: - pg_createsubscriber - JSON_TABLE - SQL/JSON constructor - SQL/JSON query functions - ON_ERROR - sslnegotiation - PQchangePassword - pg_maintain