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 1tXYyf-009no7-MQ for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Jan 2025 04:56:34 +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 1tXYyd-00FEKs-Nh for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Jan 2025 04:56:32 +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 1tXYyc-00FEK8-M6 for pgsql-hackers@lists.postgresql.org; Tue, 14 Jan 2025 04:56:31 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tXYyb-000IQY-0m for pgsql-hackers@lists.postgresql.org; Tue, 14 Jan 2025 04:56:30 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfout.stl.internal (Postfix) with ESMTP id 527E311400E3; Mon, 13 Jan 2025 23:56:27 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-11.internal (MEProxy); Mon, 13 Jan 2025 23:56:27 -0500 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:subject :subject:to:to; s=fm2; t=1736830587; x=1736916987; bh=JNzSIC3bQE V4sfMPNMNk0yq80z9mkKJQv2FYowTA6v4=; b=UujNFGhYPdiWUOPjG3Js75r0Vr CGxt1RoqtbnMC0+y07xwm7KrVDkRHOWUbMmfNeeUoNvL9RjhHvq5QtMVdCUnd7Ya XexFZ3LdnbKTQ/2qH/3N3LjIvb46JXH4Uc4iIggBPHf5rG96peVLin2lmX418x61 CuiPGS3jLY4jBiybebv0e4xRyRuRcWEekVQv6/iFCPoQ1428uN1oY8GlNr6I+fFJ EAc6MrGJEz0qmnXeTAaXQyth2RxM2FYKMqzz8xLJB4azobT7azoPawOve8GkG0ud y5d2blf9yrC95GJoGPCDvDYUZQYWGCyJU1IcgZxPdVaDyyJagNc6apTeuOwA== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1736830587; x=1736916987; bh=JNzSIC3bQEV4sfMPNMNk0yq80z9mkKJQv2F YowTA6v4=; b=dLN7wmUhlT6uJrcf8Zd38C5clF949ZdRSqdS2bk6Dn6JvQuSvHg JHRPE+bU/Co3Y2pzJY4RSHJpFGWEr7DCM3dQ5oGkF+o3vSILDVRJESRa5OR0HrNf rkQt+7gLUY3In5Noq1Fk/nmsvDWrYYp9Xlk2DeOMKWTgTfPSQLNc6anog4I/oMvI UVssdRXZCNDLErliCjsme01QcdSCbeDXo/kXgar/Q6i+RNBwDIMipQHL1lArnxj0 /l+kfnjM7c6ozgetLZaIxtxdO0m4k6bxgD7O2xoW5+RC0VItr11qudx9bETmNa/z JEEfZqqifAtnU4IcrdrgOhOeDQY3LHxtwtw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudehhedgjeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteel ieefudffhffhtdetleeggeegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhes phgrqhhuihgvrhdrgiihiidpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepsggvrhhtrhgrnhguughrohhuvhhothdrphhgsehgmhgrihhlrdgt ohhmpdhrtghpthhtohepsgihrghvuhiikedusehgmhgrihhlrdgtohhmpdhrtghpthhtoh eprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdprhgtphhtthhopehhohhr ihhkhihothgrrdhnthhtsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhh grtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 13 Jan 2025 23:56:24 -0500 (EST) Date: Tue, 14 Jan 2025 13:56:13 +0900 From: Michael Paquier To: Bertrand Drouvot Cc: Nazir Bilal Yavuz , Alvaro Herrera , Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org Subject: Re: per backend I/O statistics Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="T84qhQnfiUf5w70P" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --T84qhQnfiUf5w70P Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 10, 2025 at 01:56:01PM +0000, Bertrand Drouvot wrote: > So now, I think that it is not a good idea for the per backend stats to= =20 > behave differently than the other stats kinds. I think we should get rid = of > the "snapshot" for all of them or for none of them. Reading the above com= ments, > it looks like it has already been discussed and that the outcome is to ke= ep > it for all of them. Thanks a lot for diving into these details! I did not recall that there was a strict argument for the current behavior, even if I was pretty sure that introducing an exception for the backend stats was not quite right compared to the other stats kinds. The consistency line prevails here, then. -- Michael --T84qhQnfiUf5w70P Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmeF7m0ACgkQnvQgOdby QH02iA/+O2DmUaziUh+E2NfCO6o0kY+X1bjkQGxJnsetJJbQrAUtcDne/pd3zY1X v5hZmuXkGVNTtBUy8gDptcBpjxgacb4l0dZf7+CNjQ4AbJawLFKU0fucXl1OSyYO LovRVL77aRXFY/ToglXe88TTcB0iJXp1wi/b2i+NKmzbT/hXPi1vDxiJSQZGRLlZ JX/x6AcujDWVvQ78tUs7Bt+T8V7H5wYkjcY12+f/J1/na9ysHO4TQZYyON+d8lZ1 1OYtlSktjU1cMYQWtqZv5ypxfQneIY5foSbI9iUyN6U2t6boeBxm08IKhiUscawS pxqGAZWk8B7b2s2eDOjZVs3BHPrd0t2Xw4A/2GjpD3VW5URMW6KX/Nie5ga0+k2D xsQZgKuHqPt6o9SUlX6WNJFWe0WvmFnNd4vPYjy4YEMYUpvrghYKIEMcffdnP9Zv cFofYqHaXbfJwMqJJ9SEgGeQmFn157B8H3vEgCBKKoQydv+aHoaGvJ0UHaHVnn6z vyZDTEFsgO+idmU3AxSXnVioK6u8uOf8FUCFYsFrCfrt0ZuEMLOpbvXVbm6fEPf1 S8Crxeer83SbOnh0wJ7IOHmPLAOfKFs5ybDSzYSXKiHOzOMgwUkBZ6slKhnbFpVR yozkisLdnEHHu0Y2uQ+v26nlCsvyGbr7Z78Ku37BHPZQlpAjZfs= =0131 -----END PGP SIGNATURE----- --T84qhQnfiUf5w70P--