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 1tLM20-00EHhx-EU for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Dec 2024 12:41:32 +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 1tLM1x-00G3dH-BP for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Dec 2024 12:41:30 +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 1tLM1w-00G3d9-Qk for pgsql-hackers@lists.postgresql.org; Wed, 11 Dec 2024 12:41:30 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLM1q-002G4I-Qj for pgsql-hackers@postgresql.org; Wed, 11 Dec 2024 12:41:28 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-e39f43344c5so6152532276.1 for ; Wed, 11 Dec 2024 04:41:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lelarge-info.20230601.gappssmtp.com; s=20230601; t=1733920881; x=1734525681; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=e91F/hycQG3GxOqM7LxlMfES/xHMbYmo4KZoJoAmDQg=; b=BevM+mbca4Rxzj4aPkUfoabeqg8twB2XT5pWhJcUPtTCrIZtMfdk/KZ38SvDSh+Wrf fwC6J973NW0DQnv9hxk3Fqjl5tL/RqdoXxdRdleowgDFGZJ1WuTXCfC3L09o6RAAQYYi +ArddulpnE0VrDcYhu3W5OUJQvlDbYTnKZxCZe2fasOfnpJwCW1LzJrYV0FLOdRs7Cfm 7f43fgkXRbnq2s71Za5YTwREX6DQlrORObrr5USVRNCbpwa56hXzHwnBAvX1EViyrExe uCSW8cA0M/YcP4BopZN4ayBgOt22O34sQZoUtfv8xK5ENH95tPPk0U+wumKp1oJdQgth fZKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733920881; x=1734525681; h=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=e91F/hycQG3GxOqM7LxlMfES/xHMbYmo4KZoJoAmDQg=; b=O2MrgLDovBf+5aqgzHf0b2HMGTApMwG1Jef08tmolkHabROB/DHuV0/qohHARqFQxk WrsbF7UfefgQFByWiYv3Uk/CeszMOlYA0pcgPbL+dsm/5MVcjZSJuzU4UlWzLvEtVH1H zHoGC0aCUM3aReMECskKdtxXH4VwRNkbZxRlkjmMax8ZQ1cqCMAcDTscjHlJT6eA0ZmM QZOsA3+JKuoNE+pygrh/jimMnUKTITu4tpH9+79NP0uDC1I7A1S7ObtXBUPHwnUe5TrW QxWz4vZYlTIUOB+4Ga4hM/XF56+Zk8E32Y3QesB+rK1nQzAPVPiIGtj3TiqOUpNqbOnK NPxA== X-Forwarded-Encrypted: i=1; AJvYcCU1ikNY8rmEl00o5dh4RiE+2zKFsliTLCMcUiYduqZQMxIV+oSDpc6+JKlrC+QIYunjdN8MptDIvdnB915c@postgresql.org X-Gm-Message-State: AOJu0YzbS3bcfGUKNND24gEdEGgubqB1/yTkm7i9zfCm9uWDDMY4nZPS VpcMfYPsH85oARFBOOcHQxzy5K5MrSouw6M89398HcsSHe1ctFTWB+uBfvAaL9LM8JOO5+2AMy0 b3GYcha82XuISefmURfSc1TNMsqvPEe2lMYs8Og== X-Gm-Gg: ASbGncu2sxD7LazFqJPMzFncmIB3CrgMQBHRA7V2PELDdJEcRMVZbL0EYFA1InkAyGg eXxzIQsfqcH8EOitkzMG5Pys+cT05YjInKNE= X-Google-Smtp-Source: AGHT+IEcF94BNz5o5m4c9ZvZ3sKG5qsDTovDS8vEXWtvx15NKZJ0cLA6tGbIXRk+4aPPjMpX5S5gNMR7Xv7VdcGlUyY= X-Received: by 2002:a05:6902:2410:b0:e39:8cfe:9d36 with SMTP id 3f1490d57ef6-e3c8e45cb79mr2259436276.20.1733920881472; Wed, 11 Dec 2024 04:41:21 -0800 (PST) MIME-Version: 1.0 References: <3076356.1730831425@sss.pgh.pa.us> In-Reply-To: From: Guillaume Lelarge Date: Wed, 11 Dec 2024 13:41:09 +0100 Message-ID: Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE To: David Rowley Cc: Greg Sabino Mullane , Robert Haas , Michael Christofides , "David G. Johnston" , Nikolay Samokhvalov , Tom Lane , pgsql-hackers@postgresql.org Content-Type: multipart/alternative; boundary="0000000000003592d20628fdeab7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003592d20628fdeab7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Le mer. 11 d=C3=A9c. 2024 =C3=A0 12:16, David Rowley = a =C3=A9crit : > On Wed, 11 Dec 2024 at 22:38, David Rowley wrote: > > I've pushed the main patch. I'm not planning on pushing the > > auto_explain.log_buffers default change unless there's a bit more > > discussion about it. > > There were a few places that were missing a BUFFERS OFF as indicated > by the buildfarm. I've fixed a few of these, but there's at least one > more in pg_stat_statements's level_tracking.sql. I'm currently running > a -DRELCACHE_FORCE_RELEASE -DCATCACHE_FORCE_RELEASE enabled make > check-world. It's going to take a while, so I'll hold off doing yet > another commit to fix these until I see if the level_tracking.sql one > is the last issue to fix. > > Sorry for all those late fixes. I'll refrain from saying "Sure looks easy enough to do" from now on :) Guess this is a great example of what Robert said in http://rhaas.blogspot.com/2024/05/hacking-on-postgresql-is-really-hard.html . Anyway, thanks again for your work on this. --=20 Guillaume. --0000000000003592d20628fdeab7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Le=C2=A0mer. 11 d=C3=A9c. 2024 =C3=A0=C2=A012= :16, David Rowley <dgrowleyml@gm= ail.com> a =C3=A9crit=C2=A0:
On Wed, 11 Dec 2024 at 22:38, David Rowley <dgrowleyml@gmail.com= > wrote:
> I've pushed the main patch. I'm not planning on pushing the > auto_explain.log_buffers default change unless there's a bit more<= br> > discussion about it.

There were a few places that were missing a BUFFERS OFF as indicated
by the buildfarm. I've fixed a few of these, but there's at least o= ne
more in pg_stat_statements's level_tracking.sql. I'm currently runn= ing
a -DRELCACHE_FORCE_RELEASE -DCATCACHE_FORCE_RELEASE enabled make
check-world.=C2=A0 It's going to take a while, so I'll hold off doi= ng yet
another commit to fix these until I see if the level_tracking.sql one
is the last issue to fix.


Sorry for all those late fixes. I'= ll refrain from saying "Sure looks easy enough to do" from now on= :) Guess this is a great example of what Robert said in=C2=A0= http://rhaas.blogspot.com/2024/05/hacking-on-postgresql-is-really-hard.html= .

Anyway, thanks again for your work on this.=

=

--
Guillaume.
=
--0000000000003592d20628fdeab7--