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 1tFhwv-00FFoz-UQ for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2024 22:52:57 +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 1tFhwu-001VIh-EO for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Nov 2024 22:52: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.94.2) (envelope-from ) id 1tFhwu-001VIY-4i for pgsql-hackers@lists.postgresql.org; Mon, 25 Nov 2024 22:52:56 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFhwn-003lU8-8m for pgsql-hackers@postgresql.org; Mon, 25 Nov 2024 22:52:54 +0000 Received: by mail-lf1-x12a.google.com with SMTP id 2adb3069b0e04-53de852a287so532923e87.2 for ; Mon, 25 Nov 2024 14:52:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732575167; x=1733179967; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=cddnGLbaO2X9amFbcYamfzgRHf22Xvpwo+1+hef91ws=; b=Znwg27L+GUAY9+DhKohdkFT4DOIn5WzU5La0GKIWkPbUztd0ny3P7Ki1CPwn7VS/xx Df9DV1GsDcimVi2a3d4rtsXAXTr4Xc6N2TmeFHLwAz3MV5hUQd7nJym8QOjueMcuvA43 cez5kxXSg9vxNKum8uahIC0PLFmSrPW/Y4+230kdIxn0a4v9ScfRgt0Si/8i/0l2gRPy fscMZvSPYnAHPuDWo2okXzjpVfSQK1P+vAqfsOLMHncd7INmOQ+vNo01pYes7Kj+AAsq NQ0Q5iowvvufXrgNLgBndNrj4YyXcAmel9a6smvoyo29fzTaHfuGh25kpOenWqAWD5/+ 5VTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732575167; x=1733179967; h=content-transfer-encoding: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=cddnGLbaO2X9amFbcYamfzgRHf22Xvpwo+1+hef91ws=; b=UVCec+aEY+V+drigH4yxhLrXEHVioAHkeMnpEguNMMmW58cV+s5jKHcvQCve0wHB2f Bo8CKlDumPor/4uTBCl2HX552LiGUU4nfRImU2/tcL1xzMUDtLtE1lAaRMNp3nFJTe6g AVlAIPS/OcyqxIfN+rM1U/V5DZIwaCk1oQcpWTAmGR/33Hd9z4uOwJrPKtCXxGLQ9DkT NdBRjHU06FxTumekS6CUPTegxEBc0hGgFQWA+hBQ8gHR4ad8W/fsbeMIlNS0T3rSBOMB AhUCM1iwpYeWUjvIDkp/ohEFCRGyM+OLdZJFkUqP2JSENbk09SMuwznjfLya6WtQ1mEP FtfA== X-Forwarded-Encrypted: i=1; AJvYcCWMI2MwGa0cswvdGB3+rkKb89705AJLKxa/ODF+9pm9R0/Bwt6VQwsU4S2ht7jQ2+xEafiv19yPt4CZ5MY6@postgresql.org X-Gm-Message-State: AOJu0YxfThI/Cj/++T2myIps0blPNVGEYxptOZz7cZLrWbH8w1iid3zc DyNcqQedj9ircD/LS8Q7odx6cXQFXHtOm69TsBnFannQXx+EHzCDye7hlSqTBqRbOVoBc221PWQ 7uSr6nLPKnelI5C57Jf9BWQ9cw8c= X-Gm-Gg: ASbGncsCffalYDN8HbDWP5rBhfjZvD3z5/q86gdGbGoTWdcnho3eE+Myn2CUWPyHu2b ktVh+JLNgAQvExfhEvaZEO8LX9HsvVzTvzpwYmK/wUU7X+iahthfwnXDKgFUih54y X-Google-Smtp-Source: AGHT+IGr7dfBIFcCuPc0JMTRW4zFR7+mXxQa3Rq03R/YYFuDzrmUnPVHDSgzZmU7r2eA8tXCeltraLJFrkCR0MhkxTc= X-Received: by 2002:a05:6512:3406:b0:539:f630:f233 with SMTP id 2adb3069b0e04-53dd3aabcf0mr6114750e87.57.1732575166977; Mon, 25 Nov 2024 14:52:46 -0800 (PST) MIME-Version: 1.0 References: <3076356.1730831425@sss.pgh.pa.us> In-Reply-To: From: David Rowley Date: Tue, 26 Nov 2024 11:52:34 +1300 Message-ID: Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE To: Robert Haas Cc: Guillaume Lelarge , Greg Sabino Mullane , Michael Christofides , "David G. Johnston" , Nikolay Samokhvalov , Tom Lane , pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 26 Nov 2024 at 09:44, Robert Haas wrote: > > On Wed, Nov 20, 2024 at 4:23=E2=80=AFPM David Rowley wrote: > > I think this might be a good time for anyone out there who is against > > turning on BUFFERS when ANALYZE is on to speak up. > > > > Votes for changing this so far seem to be: Me, Michael Christofides, > > Guillaume Lelarge, Robert, Greg Sabino Mullane, and David Fetter (from > > 2020) [1]. > > > > Votes against: None > > Just to be clear, my vote is more like +0 than +1. I recognize that > changing this is popular and I'm not opposed to it, but I'm also not > unhappy with things as they are. OK, thanks. I likely took your neutrality here in a more positive light after reading the 4-year-old message at [1]. That probably wasn't the right thing to do. There are still no votes against it, so unless some come in, I plan to start looking at the patches proposed to turn buffers on with analyze with my committer hat on. David [1] https://www.postgresql.org/message-id/CA%2BTgmoYH_p-y%3D45SAJ58cU6jsMH6= ojgqQZiA2aePpvZ0J%2BuLbA%40mail.gmail.com