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 1pv7a6-000158-BZ for pgsql-hackers@arkaria.postgresql.org; Sat, 06 May 2023 02:23:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pv7a5-0006f1-1a for pgsql-hackers@arkaria.postgresql.org; Sat, 06 May 2023 02:23:29 +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 1pv7a3-0006cs-EW for pgsql-hackers@lists.postgresql.org; Sat, 06 May 2023 02:23:28 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pv7a0-000mSW-21 for pgsql-hackers@lists.postgresql.org; Sat, 06 May 2023 02:23:25 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id DCC9F5C00D7; Fri, 5 May 2023 22:23:21 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Fri, 05 May 2023 22:23:21 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1683339801; x=1683426201; bh=I4 +YBE7GF+DfjYuXMi7BTc4pQ8x2lRJKuSoESmhlKC8=; b=ucXw4/pGWNf2niEauX kv0CUS+sb8KFiR4hVqClwpNqiJNSdPgsDH4UkMpJWYeOGipJ1cHBIv2B8n++5NmZ ObpVFvJ/vp+aZx3/pIKgn85X29gl7QP0FPR498s+7Uga88Q6rMbwFeBW0iWLtysn KvJCeR6ahZuYT7GSK6JbP3N6ACdR8K51hwgh4np0OQwD6o76TfttnUpvyp5A9SHU FYl0xg9iAeSN4ggo8l8ARSKsDCgGnc0E0v+MSEdbqiXeEifc1aL1CyNVT2WvlBbD SSRtA3fKrYPKfbQF4xNUgSpcYHerxqdDUCcy2gR0j3poy61I8mrBkZaxMpny2Vt9 iLuA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1683339801; x=1683426201; bh=I4+YBE7GF+Dfj YuXMi7BTc4pQ8x2lRJKuSoESmhlKC8=; b=bAWoZUQopYRj39faJ66QSEsFZEVNq dMUk884fWZmBAA5MoIn6Lp0JmlM69NTDN9hnUSm9+Unu1JUrBAnXBWFXiOrh1Gr9 VQbdi3GdNXY56fsevzUKj2fcgp5DBuzyYrj3nvUhN6oSdTwtztctd7devd68qx6Z Gg9h1RgCdnyeVfiaHiBbc/psfWAieTD0Wj8Y/NYrsaY+eqpRmViHDhd1ff2GRdkU 8lBexwjsI7seEzRgSxs8A+nUD+YizDPA12Yj+C9+lR7QWl6hdRnaZ32RXN5K/1H+ kNDu+rQc0IqNHcVXT+UJVK7TZvS2J58hT2Jg5e+mG5xL45vruhTdzLkqg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeeffedgheelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtdggredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteeggffgfedtleehhfdvvedu keetvdelgeefkeelkeeukefhvefgudetleetheeinecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 5 May 2023 22:23:20 -0400 (EDT) Date: Sat, 6 May 2023 11:23:17 +0900 From: Michael Paquier To: "Drouvot, Bertrand" Cc: PostgreSQL Hackers Subject: Re: Autogenerate some wait events code and documentation Message-ID: References: <2e649ed7-6c66-5d6a-16d4-5d5367d40e69@gmail.com> <64fc361e-f4ed-45eb-0cfb-c8110872530d@gmail.com> <124bdcea-bdc8-e3d2-2357-0c6a857bc557@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qSp6HBflPb2Ssb9+" Content-Disposition: inline In-Reply-To: <124bdcea-bdc8-e3d2-2357-0c6a857bc557@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --qSp6HBflPb2Ssb9+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, May 04, 2023 at 08:39:49AM +0200, Drouvot, Bertrand wrote: > On 5/1/23 1:59 AM, Michael Paquier wrote: > I'm not sure I like it. First, it does break the "Note" ordering as compa= re > to the current documentation. That's not a big deal though. >=20 > Secondly, what If we need to add some note(s) in the future for > another wait class? Having all the notes after all the tables are > generated would sound weird to me. Appending these notes at the end of all the tables does not strike me as a big dea, TBH. But, well, my sole opinion is not the final choice either. For now, I am mostly tempted to keep the generation script as minimalistic as possible. > We could discuss another approach for the "Note" part if there is a > need to add one for an existing/new wait class though. Documenting what's expected from the wait event classes is critical in the .txt file as that's what developers are going to look at when adding a new wait event. Adding them in the header is less appealing to me considering that is it now generated, and the docs provide a lot of explanation as well. >> This has as extra consequence to require a change in >> wait_event.h so as PG_WAIT_BUFFER_PIN is renamed to PG_WAIT_BUFFERPIN, >> equally fine by me. Logically, this rename should be done in a patch >> of its own, for clarity. >=20 > Yes, I can look at it. > [...] > Agree, I'll look at this. Thanks! > I'll look at v7 when the v17 branch opens and propose the separate patch > mentioned above at that time too. Thanks, again. -- Michael --qSp6HBflPb2Ssb9+ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmRVuhUACgkQnvQgOdby QH3gwA//W9OjsnQ1HvGdW6dxXZnXnm9Cr4YqN4mkbtDeUG65rywkMPbwswcCtfg3 U9T0exNPV72I21MAOKLVWqYjPS64zmBE+KhixKL6vYHN5n9j+JawwYCJWHP39wn0 qk0LIz2YbJe3gSATBkv6gZSJFutN6A2QXMPsFWACQP3voWDKhaukzWWraPU3Uw6x gtFxuEpURH6EwqyHYYMYO3/JUsafTlDu5jIJCyqumpT7epH+JdVyTsSLKR/N9VPn D86x5yCS3FXBm2v0bo/Yd3uEwS79VKpNDLll6nSGFagmsq1rgba56fkuTrit8ISR sqK4ji9sb166UKYJHBBCiO034qSryVyM3NOK7xGWVOOVtmk2n2HQy0B9Ra+gj+rM r2oKwjcVWwz2D9S1fEaRP/KhUdTeC/SnOvxWIevMhgkRMejHUYNjG6HFXYZ9hPeV kzV5dbzYj84IDH+8RDuoRMCR2VuUFH1JaALz4bxAsjPtPqtux3Bz42UIV2k7AhJC ICP0jxUvcjRKNA8y3rbPlyqHtDGQ1iG0zva5jagLMAfMLXNUPaR0OhZp1G3bpJIH 3qSucP88r/cUW16GtnG+D3owLTLYeABa83UszrbY3bPW4NmOJ/3UlSpZDlJ3+PYE 9SkUPerDeWR7hoMtbi8zoXQOt1oobc4xgkhP2LIvW7OwnBM4mfc= =gfEl -----END PGP SIGNATURE----- --qSp6HBflPb2Ssb9+--