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 1s7R53-005gsX-H6 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 02:42:54 +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 1s7R53-00DnUu-HF for pgsql-hackers@arkaria.postgresql.org; Thu, 16 May 2024 02:42:53 +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.94.2) (envelope-from ) id 1s7R53-00DnPR-6F for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 02:42:53 +0000 Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s7R4z-000TBd-A8 for pgsql-hackers@lists.postgresql.org; Thu, 16 May 2024 02:42:52 +0000 Received: by mail-lf1-x131.google.com with SMTP id 2adb3069b0e04-51f45104ef0so278572e87.3 for ; Wed, 15 May 2024 19:42:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715827369; x=1716432169; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=SfRBudPjEJN+U4zG95eBs6dyKsIMso2pQXoxMO4vub4=; b=XeiJ0SDHUn53rg3ZDTbXY7kRlv5bXoLLvLBt1zkG8DIPPUJTg7MGD6x90SVqdCkP/b iUV+2/PvboNsebLnlKZbU6uR+Xh5sOlu2eEKbF3eq9D4HK3gI0T2NPxvSvaE9fEh+oI3 kAMvOKuhrs8cUfiqZchvED0ogrqj6SwHRF4utI4B+XlXRGnuul4z9XwO9PooyEEwP9iQ B8vQMJAdtP7BNESDG6CGyKyMlFTDEZiOeZMz3ZVreF4u5gmvQf5+3IG6Hj+oWqMlbygZ J7/KywR/0DzK4HQcnbeeeCW/sGJSy8C6aMeVWvZyrn/KA5kZrJaZPR58myuAX1wfkScO AQ1g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715827369; x=1716432169; 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=SfRBudPjEJN+U4zG95eBs6dyKsIMso2pQXoxMO4vub4=; b=uqlx6MW0BDt8IXjhljwRyAcGnlL9u+aWLYJ5UAJYBCC6tc3tXil3DA7+mwTV+802hs h4llzPT6asbqHf91rgdgUn2QUwKd7Pkae0qAwgJQNWAWPKOb6ODgc98l4vyL+uuBNhrR UJGWJ9Lfih2mJQt9z0FmZLw+Uf2dPTyQjmoLtYsb1lWoBPhfdXKIAnnj9ZopuYzKV4Dh TybeVx18+7mngXdrG35HwN6YOcHv1ehP11tE80KAMf/URRuq8PPOZ/ARFzQe3QLXPQD0 v4XL7k4pqeRJwiLZyTchYo9t2UnnDn5olCuH8m0QAFjaffrNbBIE0VXVQcNEoC7Z1kwe Actg== X-Gm-Message-State: AOJu0YxZpYiaYF8gTzWPrS26+B28EcdzgS0LvnrgIKIXaPwLK+JJyzFI Gz7fHOtu/bFQ+Miba4YBT2tGvsnDAAw55WHJmsXSFqQ9Qceus1Jg9DTXMERIeaV+KQjxtv4iBNW MkJfhR/n1he+oxqkL3vtZ6/z8fKU= X-Google-Smtp-Source: AGHT+IEgUoDOcIzG6itdAfI4W3eIIZ1SFCLJSmazfRQ23fFF7Yhllv1ivDp6aF9I3YJ4YbcQ3QY0y2B68Mgn0fxzBik= X-Received: by 2002:a19:8c58:0:b0:521:7543:4534 with SMTP id 2adb3069b0e04-5220ff74bb3mr10106416e87.62.1715827369071; Wed, 15 May 2024 19:42:49 -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: David Rowley Date: Thu, 16 May 2024 14:42:37 +1200 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 Thanks for writing that up. It's always exciting to see this each year. On Thu, 16 May 2024 at 13:45, Jonathan S. Katz wrote: > * Please indicate if you believe there's a notable omission, or if we > should omit any of these callouts I'd say the streaming read stuff added in b5a9b18cd and subsequent commits like b7b0f3f27 and 041b96802 are worth a mention. I'd be happy to see this over the IS NOT NULL qual stuff that I worked on in there or even the AVX512 bit counting. Speeding up a backwater aggregate function is nice, but IMO, not compatible with reducing the number reads. There's some benchmarking in a youtube video: https://youtu.be/QAYzWAlxCYc?si=L0UT6Lrf067ZBv46&t=237 > * Please indicate if a description is confusing - I'm happy to rewrite > to ensure it's clearer. > > Please provide feedback no later than Wed 2024-05-22 18:00 UTC. The only other thing I saw from a quick read was a stray "the" in "the copy proceed even if the there is an error inserting a row." David