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 1tgRSz-00Ai4U-KS for pgsql-general@arkaria.postgresql.org; Fri, 07 Feb 2025 16:44: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 1tgRSy-0034Y2-Np for pgsql-general@arkaria.postgresql.org; Fri, 07 Feb 2025 16:44:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tgRSy-0034Xt-DK for pgsql-general@lists.postgresql.org; Fri, 07 Feb 2025 16:44:32 +0000 Received: from relay9-d.mail.gandi.net ([2001:4b98:dc4:8::229]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tgRSv-004OZu-2G for pgsql-general@lists.postgresql.org; Fri, 07 Feb 2025 16:44:31 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id 1E14A442EE; Fri, 7 Feb 2025 16:44:27 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vondra.me; s=gm1; t=1738946668; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=tPaLtuu9nE/tniKOr9wGZqb2ynPq3n4SxhkCUlS44T0=; b=U4eAEPBPr9rTTocB1Rn47TVuD5CKZapode/zpTaxxmalgmFPzb8bG/ET7fximDWJtownEA isfnXsx6R7tkVu7sqJlDqqXlj3+fTEemSVbDWmuwwKZWYzEMSC1BvHLgahRrV5I7VwAn8r 5sg4+vgx2d91BbGrbqkptCnz2ZvkQnxFE57lWJS80UBKPVIabJhhxYrkTirVwpweIcG2bQ cOMSMPZR4fdU8mWXGQ3/K+GhrSGvIUA4JNgZdij0yNe39qM56KgGSCJpkcHp36pzMF7ZXW OLD3/v/Q4EPTWQb3xj09yBoPPTSDfs8jysNItDOXcKvhEN4kKrvc+QKldg2GJA== Message-ID: Date: Fri, 7 Feb 2025 17:44:26 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Commit Latency To: ravi k , =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: Ramakrishna m , pgsql-general References: <202502051537.rpohgrxu4vrz@alvherre.pgsql> Content-Language: en-US From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-GND-State: clean X-GND-Score: 0 X-GND-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvleejlecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfitefpfffkpdcuggftfghnshhusghstghrihgsvgenuceurghilhhouhhtmecufedtudenucenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomhepvfhomhgrshcugghonhgurhgruceothhomhgrshesvhhonhgurhgrrdhmvgeqnecuggftrfgrthhtvghrnhepledugeeikefglefhgfffuedvleetteevgefhvdeikeefudduuddvhfevudefhfevnecukfhppeekiedrgeelrddvfeeirdduleefnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehinhgvthepkeeirdegledrvdefiedrudelfedphhgvlhhopegluddtrddufeejrddtrddvngdpmhgrihhlfhhrohhmpehtohhmrghssehvohhnughrrgdrmhgvpdhnsggprhgtphhtthhopeegpdhrtghpthhtoheprhgrvhhishhqlhdtleesghhmrghilhdrtghomhdprhgtphhtthhopegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhrtghpthhtoheprhgrmhdrphhguggssehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-GND-Sasl: tomas@vondra.me List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/7/25 14:00, ravi k wrote: > Thanks for the suggestions! > > It looks the issue is happening at the time of wal creation, does > wal_init_zero off is good option? > It's impossible to say if that option will help, considering how little info about the system you provided. I suggest you start by answering the questions you've been asked by me & Alvaro, explain why you concluded it's related to WAL creation, etc. regards -- Tomas Vondra