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 1srIoL-000Uee-LY for pgsql-general@arkaria.postgresql.org; Thu, 19 Sep 2024 15:11:14 +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 1srInL-002hAf-ML for pgsql-general@arkaria.postgresql.org; Thu, 19 Sep 2024 15:10:13 +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 1srInL-002hAW-Bj for pgsql-general@lists.postgresql.org; Thu, 19 Sep 2024 15:10:12 +0000 Received: from fhigh1-smtp.messagingengine.com ([103.168.172.152]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srInK-0001ZG-6v for pgsql-general@lists.postgresql.org; Thu, 19 Sep 2024 15:10:11 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.phl.internal (Postfix) with ESMTP id 2BC3711401C8; Thu, 19 Sep 2024 11:10:09 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Thu, 19 Sep 2024 11:10:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding: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=fm1; t=1726758609; x=1726845009; bh=45gCEFT11spb9koHSTnujoeyFGfvIFGDMZfi2x+wZCI=; b= TGX3579p2yTfuBrSpQ2d/V5ZCr4Mth5f/7s+gb6Mx2RqOho51gUpGjYNH9qd4aVQ +19Cn+cGl5S2vaTjFw2cbxiKzuFPT3yoQ7DBiUhaNsfla3VqpbEwcN4zGkBfDKgJ KT2EDQlqo0Wr0EPZfKmtbtocS31SqcWgL4YWuo3ihgH7IQTZgg+qwGzzypSr+a4G E7/NktmgW6cp9aBGKNVSLwt9h/TeC9oYdn3mSyLUHbm1455s4+uvw4upOwiysWv9 9dJZfITcPDXuRGfjfmm2xF1icSnyOZQWzfZCbIShc/VFjcvZzawIcCQo59Up948d objYBrfM8ZgArQHhJPq7KA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1726758609; x= 1726845009; bh=45gCEFT11spb9koHSTnujoeyFGfvIFGDMZfi2x+wZCI=; b=l h/H2feXUs9iGgMKv8MRH9MXG7iCMKZ81wMeeSthOGet3R8SZkTZ67+WaBRqOblMV 9PnBzOvV68kFIdrx5uCF95PgsB8/AXeyEV8COkNPfj2ncph2Zq2k6juhXLxbvIfF DbLiQ47j8C9HRqtFb75uizyozwo1YshSuKfziDUS0EOAjkLip3w70XbUbRu3rvxW oBcu5YEWELi3dLZLfmaq/WQMzfG6eZZAgZAlxOAVUKYSihEfj/H17cpmJ37SZylB IIcjo3k9t2mhla/98WN8DyXTpAqxJLRm2BIjoZNt3SUiWxuoJoYMRSkCmCBhSzOM d88udH1SZ21vEgvDov5OA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudeluddgkeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepfeegfeeiuedtgffgteeg gfehkeejheetieeliefgteeikeejvdeiveeigfehvedtnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtohephhhtrghmfhhiughssehgmhgrihhlrdgtohhmpdhrtghpthhtohepvhgv vghmrgdttddttdesghhmrghilhdrtghomhdprhgtphhtthhopeigohhfsehthhgvsghuih hlugdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhp ohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 19 Sep 2024 11:10:08 -0400 (EDT) Message-ID: Date: Thu, 19 Sep 2024 08:10:07 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: IO related waits To: Greg Sabino Mullane , veem v Cc: Christophe Pettus , pgsql-general References: <3dddea5e-52ab-4075-970d-a87b0c921ae7@aklaver.com> <225d1bc1-5117-4c72-85a1-bac6355fb659@aklaver.com> <586d988d-978b-4b08-84b4-ef3ebb8736a8@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/19/24 05:24, Greg Sabino Mullane wrote: > On Thu, Sep 19, 2024 at 5:17 AM veem v This is really difficult to diagnose from afar with only snippets of > logs and half-complete descriptions of your business logic. Pull > everyone involved into a room with a whiteboard, and produce a document > describing exactly what your application does, and how it is doing it. > Switch from reactive to proactive. +1 > > Cheers, > Greg > -- Adrian Klaver adrian.klaver@aklaver.com