Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hT8jG-0001R3-0Y for pgsql-hackers@arkaria.postgresql.org; Tue, 21 May 2019 17:39:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hT8jD-000281-Vv for pgsql-hackers@arkaria.postgresql.org; Tue, 21 May 2019 17:39:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hT8jD-00027f-Ms for pgsql-hackers@lists.postgresql.org; Tue, 21 May 2019 17:39:07 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hT8j6-0005H3-Js for pgsql-hackers@postgresql.org; Tue, 21 May 2019 17:39:07 +0000 Received: by fetter.org (Postfix, from userid 1001) id 6508C40460; Tue, 21 May 2019 19:38:58 +0200 (CEST) Date: Tue, 21 May 2019 19:38:57 +0200 From: David Fetter To: Robert Haas Cc: Tom Lane , Alvaro Herrera , Andres Freund , Stephen Frost , PostgreSQL Development Subject: Re: New EXPLAIN option: ALL Message-ID: <20190521173857.GH28936@fetter.org> References: <20190515170529.GA18938@alvherre.pgsql> <11598.1557942806@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, May 21, 2019 at 12:32:21PM -0400, Robert Haas wrote: > On Wed, May 15, 2019 at 1:53 PM Tom Lane wrote: > > >> That seems too confusing. > > > > > Ok. Are you voting for using EXEC as a keyword to replace ANALYZE? > > > > FWIW, given the conflict against "EXPLAIN EXECUTE prepared_stmt_name", > > we should probably just drop the whole idea. It seemed like a great > > idea at the time, but it's going to confuse people not just Bison. > > +1. I think trying to replace ANALYZE with something else is setting > ourselves up for years, possibly decades, worth of confusion. And > without any real benefit. > > Defaulting BUFFERS to ON is probably a reasonable change, thuogh. Would this be worth back-patching? I ask because adding it will cause fairly large (if mechanical) churn in the regression tests. Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate