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 1oLUkr-0005FD-2V for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 19:19:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLUjr-0000Yk-54 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 19:18:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLUjq-0000Yb-S2 for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 19:18:02 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLUjo-0005km-MO; Tue, 09 Aug 2022 19:18:02 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 279JHidZ035779; Tue, 9 Aug 2022 15:17:44 -0400 From: Tom Lane To: "Jonathan S. Katz" cc: Andrew Dunstan , Andres Freund , Amit Langote , David Rowley , Alvaro Herrera , Michael Paquier , John Naylor , Peter Geoghegan , PostgreSQL-development , Nikita Glukhov Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size In-reply-to: <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> References: <20220721171235.7okm3q5i7jyuwtqw@alvherre.pgsql> <20220802003947.x2ezq7u7pkmxt6ie@awork3.anarazel.de> <20220802150022.jqomxwum5eazybfv@awork3.anarazel.de> <20220805203656.mdgmajvsahi5srcy@awork3.anarazel.de> <787cef45-15de-8f1d-ed58-a1c1435bfc0e@postgresql.org> <32d4a1e4-d218-b129-205e-e123ebaef6b8@dunslane.net> <4b02e8a0-2541-a739-d1e7-6cdd29239b24@postgresql.org> Comments: In-reply-to "Jonathan S. Katz" message dated "Tue, 09 Aug 2022 14:04:48 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <35777.1660072664.1@sss.pgh.pa.us> Date: Tue, 09 Aug 2022 15:17:44 -0400 Message-ID: <35778.1660072664@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Jonathan S. Katz" writes: > Speaking personally, I would like to see what we could do to include > support for this batch of the SQL/JSON features in v15. What is included > looks like it closes most of the gap on what we've been missing > syntactically since the standard was adopted, and the JSON_TABLE work is > very convenient for converting JSON data into a relational format. I > believe having this feature set is important for maintaining standards > compliance, interoperability, tooling support, and general usability. > Plus, JSON still seems to be pretty popular :) > ... > I hope that these can be addressed satisfactorily in a reasonable (read: > now a much shorter) timeframe so we can include the SQL/JSON work in v15. We have delayed releases for $COOL_FEATURE in the past, and I think our batting average on that is still .000: not once has it worked out well. I think we're better off getting the pain over with quickly, so I regretfully vote for revert. And for a full redesign/rewrite before we try again; based on Andres' comments, it needs that. regards, tom lane