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.96) (envelope-from ) id 1wWqRK-002tRH-0D for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jun 2026 06:59:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wWqRI-005SVA-2D for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jun 2026 06:59:56 +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.96) (envelope-from ) id 1wWqRI-005SV1-0z for pgsql-hackers@lists.postgresql.org; Tue, 09 Jun 2026 06:59:56 +0000 Received: from mail-dy1-x132d.google.com ([2607:f8b0:4864:20::132d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wWqRG-00000001oCK-29K8 for pgsql-hackers@lists.postgresql.org; Tue, 09 Jun 2026 06:59:55 +0000 Received: by mail-dy1-x132d.google.com with SMTP id 5a478bee46e88-304cf518c9dso6335090eec.1 for ; Mon, 08 Jun 2026 23:59:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1780988393; x=1781593193; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=4SJB8ba/SuDYxvuGaAzcQF4JL2E1vRWwER5ANT4jMvw=; b=WG9MqrYXGWKry+eZPGuDjgVRgYdCWDCkb/EANZEF55Elk/xTTGhyA/wXYbJM/03Vt4 5dbIY3lLqoMK0BBy8oBNB7aGJle8lEr2Iubjx2IKt6iT+7EjvzXZttnIl0XuICo8QFxs J7u9fiEKPpdDwQypw95XAS0mcMZncdlpAJpZPuH3KohIpvfcIivAlbbO9tA9lFHdxCIu yxLA7HVS22f3xOYk74+w0zWxZ6+qKjbi8Mwmdhz6/ydsE6CPyDQhlgGFP7PzRSixpnDF m9pA5g3r+SKM6pCQGnQA74L0TIE0Ki1bvmd+lZQ4l4WiEnApb3rdhmYFh9nwdOcEvzYN 1zwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780988393; x=1781593193; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=4SJB8ba/SuDYxvuGaAzcQF4JL2E1vRWwER5ANT4jMvw=; b=OxhIHd1SZ6kA3dB5TcdRkdV36K5YB+dmSdWFWPSo5hA2cBfGXlO0ILHq5V4DD6WqXO gUkLhFi4mIbarRUoXOzKHzc6s3hrw2C5JwITyljMZZCnoTG/ND/bD+DzLiIR2LLKhR4G fnRuxd960/apyso7eDquJm03yNMh7nhvDgfo/1lc3PwnvNY+WUr08472RnI61HJxJHGO 92W/ZqXIEQoWvjMwRulXae274Gu6XRmfcPeA1nq2z2aWiKvCVfriwzafgox54nknr1mv vF0SkN74SW5dcMxr31oqx9uV7ycnpSQwPL75han0MKAPwxEyRCj8GkDuZpmTHg3wAQ/G QtNQ== X-Gm-Message-State: AOJu0YwWfCgbqBvfMeKerBvK5dRRCWUVIFUQVdVfZAKKaoHUOnZA7dRT lTTck7990HRIIMmDdg+TmHcLDy4hOANhwixfxfSfHTgIb/t9qHrV2E47 X-Gm-Gg: Acq92OEyjy+z8hmyOUXU2FI32Uztf4mj+qxLSUCKk12L8OJ+FtSmIaehoV2yUFnDQtx 9BUFdpyeinzOHdklyKQkztWVNBkgE3AeAjafBE14epqclemPSg3MIqyl5yap1MVuuWx0vVVdxaP LDbBJ1RZrk3S5+V5rEr6C/MT/dsYwkWq5oWZlE9cXfexBvTvP25g+Jo55/Mqzq6C0zQVO+oVjVV 2Zbhz4YudSdSOvSkEI0qOddFTOSA1fPxiIUCoBh6Dopt+uqr57lIk7360Lor1PRWXZTEqLMRYM0 scw1NO4kxzh909f0b+JWT4FLtNDEZLeSZ3uAKO0fFEZgtGz2me9HtaqLAcbrhVOjeR8GS5FCVbD lip7XoaR9EvKWgfu1pLbKqWvCrn/VS/HLXWdyYTE2dG72eWnIhtYL3bNuFkRa/9oKDhrOoNFPew AO/XHT1a7nAdeMHnJe98CKdHv+ivwMykNHOhyiw94/ X-Received: by 2002:a05:693c:3b04:b0:307:42fc:584d with SMTP id 5a478bee46e88-3077b10bf32mr11346431eec.17.1780988393164; Mon, 08 Jun 2026 23:59:53 -0700 (PDT) Received: from smtpclient.apple ([64.32.14.230]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-3074dea9226sm20007666eec.19.2026.06.08.23.59.51 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 08 Jun 2026 23:59:52 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\)) Subject: Re: First draft of PG 19 release notes From: Chao Li In-Reply-To: Date: Tue, 9 Jun 2026 14:59:17 +0800 Cc: PostgreSQL-development Content-Transfer-Encoding: quoted-printable Message-Id: <402C0CBE-B5C3-41BD-9D6D-E739B9E1E390@gmail.com> References: To: Bruce Momjian X-Mailer: Apple Mail (2.3864.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 8, 2026, at 22:13, Bruce Momjian wrote: >=20 > On Sun, Jun 7, 2026 at 11:43:16PM -0400, Bruce Momjian wrote: >>> * In section E.1.3.1.1 Optimizer, I think the item >>> "Allow extended statistics on virtual generated columns" >>> should come before all other items, because it's the only one that >>> requires user action in order for them to take advantage of it. = All >>> the other items refer to some optimization that occurs = automatically. >>=20 >> While the first item in each section is the most important, I then = list >> later items in groups that have similar characteristics, which I = think >> simplifies reading. While I could order all items in importance = order, >> I think it would be much more confusing to read. Right now the item = you >> mention is in a group of items about optimizer statistics. >=20 > Actually, if there is no "most important" item in a section, I just > order by placing the largest group of similar items first. Here are = the > detais: >=20 > https://wiki.postgresql.org/wiki/Creating_Major_Release_Notes > order inside of sections > most important item first in section > if none, then largest group first > group similar items together > order group by item importance > ideally the last item in a group will relate to the = first item in the next group >=20 > --=20 > Bruce Momjian https://momjian.us > EDB https://enterprisedb.com >=20 > Do not let urgent matters crowd out time for investment in the = future. >=20 >=20 Hi Bruce, This feature has been reverted by = a0354e29c41a9fb7491b3c7c23f079b1923c045a. ``` Allow the addition of columns = based on domains containing constraints to usually avoid a table rewrite = (Jian He) § Previously this always required a table rewrite. ``` So this item can be removed from the release note. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/