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 1lgaEK-0006uL-2z for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 21:47:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lgaEI-0004dK-OW for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 21:47:50 +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 1lgaEH-0004dC-KN for pgsql-hackers@lists.postgresql.org; Tue, 11 May 2021 21:47:50 +0000 Received: from [64.147.123.25] (helo=wout2-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgaEA-0006SO-Sg for pgsql-hackers@postgresql.org; Tue, 11 May 2021 21:47:48 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id 2A28D1740; Tue, 11 May 2021 17:47:31 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Tue, 11 May 2021 17:47:31 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=O9YiRBNw8DJejDi9FTvAEhUyb5E+n67yN4PFFVXcHWs=; b=oJHlgPjt jpsUzdKc59YQzjgSm1BI4IoAUB/KVu4k5wNtrjp1OBJocHBwLvzyjrXLUdETccc/ eJ7MBtFLSxPXBL+Ffl96QN1Lo3TuZ+h5FS1QXmwSG1HDRL2jiqQ9RGtag6Y81ADd MH4JWFZNgRST/jwNLo0sg0dgXbxo5l713YsbuaOecn8XltaEfd/J3cO4jII/h7Fd kqxYoSpqQqa7PN3NcGRFumFyMuYcx80NnY+A5o3QsuCimDcGpZjSvZ7X0HjUUdTl aZjvhb/+g1hiAz8hXfW26utx0IKChe8HSSt/FbhNUHJdjb52uhAtSxa3EqsH1bFr WyV4uTu2Kha41Q== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdehuddgtdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjfgesthekredttderudenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepueffhfejieeuueffgedvudekgeeltdeviedvieeufeei ieevgfetheeufeethedvnecukfhppeduledtrdelhedrudelrdelheenucevlhhushhtvg hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghl vhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 11 May 2021 17:47:29 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2E4E92A0BB7; Tue, 11 May 2021 17:47:27 -0400 (-04) Date: Tue, 11 May 2021 17:47:27 -0400 From: Alvaro Herrera To: Bruce Momjian Cc: Justin Pryzby , PostgreSQL-development Subject: Re: PG 14 release notes, first draft Message-ID: <20210511214727.GA12299@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210511211937.GD6088@momjian.us> User-Agent: Mutt/1.10.1 (2018-07-13) X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-May-11, Bruce Momjian wrote: > > 86dc90056d Rework planning and execution of UPDATE and DELETE. > > a1115fa078 Postpone some more stuff out of ExecInitModifyTable. > > c5b7ba4e67 Postpone some stuff out of ExecInitModifyTable. Are these the set that means UPDATE/DELETE can now do partition pruning? I think that's a significant improvement, because table partitioning becomes usable in situations where it previously wasn't, so let's mention it. > > c7aba7c14e Support subscripting of arbitrary types, not only arrays. There's an entry that says we allow subscripting of jsonb, but the feature is more general than that: our subscripting is now extensible, and jsonb is just the first implementation. I think this should be mentioned. > > f40c6969d0 Routine usage information schema tables This is one small step towards compliance, I think, so it should be mentioned. -- Álvaro Herrera 39°49'30"S 73°17'W