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 1tfezZ-0044ea-Cj for pgsql-general@arkaria.postgresql.org; Wed, 05 Feb 2025 12:58:57 +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 1tfezY-00EWMl-9u for pgsql-general@arkaria.postgresql.org; Wed, 05 Feb 2025 12:58:56 +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 1tfezX-00EWMc-Uy for pgsql-general@lists.postgresql.org; Wed, 05 Feb 2025 12:58:55 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tfezV-003JVR-2R for pgsql-general@lists.postgresql.org; Wed, 05 Feb 2025 12:58:55 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-ab6fb2940d4so156549166b.1 for ; Wed, 05 Feb 2025 04:58:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1738760332; x=1739365132; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=fSgT8BeSp8HM03TDxC9BEGVRjdPWzNtDjdSAcrx/8mQ=; b=feaaX4S7Hat6dRZheZfpKCWxesR6IB3UjG2eT9U5ZocbaxD37lYnZqyECGwAcQvmVW J7cUnheBfVl9fi3CT5yiaGKYjigoS1OCcPVrMuOgm0I8tcZUJIXH4O2k7CppDIp5L85M NC6TTo2TEZ7lIM5pUpkOi6XJKgSd88pI/YMoztF1NsEh+g7JuFuNdLLYZzd6QduFaplA zGAfBWY2kAgTw3Fd4L36Hzih2J72c4hPxQNcNt0HcyzQgFAuYyGIRouOYNZvHqM9kloU wQlTwE/98Z/hvFhkxDicZtMMHbEJqA+7tA6Mp5vYoXW7LRHd8RSbQIpjeiuoozwVQpGr JU7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738760332; x=1739365132; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=fSgT8BeSp8HM03TDxC9BEGVRjdPWzNtDjdSAcrx/8mQ=; b=q8TVmybp998Pl65/wGkPY6CKlbPcjb/9TOfpbRk95x0r2LgL9VYYPXZ6TTTHcYLsNf 5CfxP6b5WrIqqBGIJ0dwMn1puBckOdAQkoCoKMlj1Dezsn7V4tJoiD1UlM2fCAGXMk6s ZmSSD4DiUobdMoh5gkCpT3NMfTKA177UTEKZmCXOb5lRxEWuntRBR7oKcYV723ZfdLsW TrRb8ob9B28h7usNXYMMBbde5qzZAvMkhVC+NvB/uo5GcDWrR0wDb5HwyJ53oATfXluS 5YrNq4puirNfzQ1AJKZ8CIkMj8Nzx+7tVO7HCgosBuQSjtjJpHj68+N6ZpVXNOW1PY1+ wqBg== X-Forwarded-Encrypted: i=1; AJvYcCVSwVa81ZowpvLRVEONQoi63wIN7eJKFxbZlyoLgoZlRxtJ+b1g2vK+KclzNVop3qTBBwWe54BO9KOO9R0g@lists.postgresql.org X-Gm-Message-State: AOJu0Yycgq77qEaaCk4idi2z8Lgrt+lZzify3f7SS+snoi3lhN1XT+3Q sfQRC4K/IHS8P4FFGCJ/2WPGtWSnR1W1Wp8ju6Bcu8fWNpNHHPDPefr68AGsfxA= X-Gm-Gg: ASbGncumA6zlY7enjV40zTChyfqnYoXKjsMRFYSrkhXc7q9/7kp5BXiSDtU+TFXQ6Wc 4u4BfKxNSvalSdUUxb9weisPG3hYv+NjiAcZAMPXiXboDL6x79B4T/QI1NCZRXLzj4+xrcPKvFO LXkioi5lq161a0xM7WB1M+Nl0lcToRIOuEO4vPnVALRNPiSAoM/UU9v6O5PJ2LlQvUF6H40jT61 /k96MTLGgCxNu/eey4qlN6hWpobjVJqgAMI4mM2LJPOrGxTW9FVnhh1LZrsb++Qm+R0cGS694hi /3o9DN3ykTA+I3uxTYTGfppaxphHViW8i5M= X-Google-Smtp-Source: AGHT+IFYXqD07Qry/7k74AF5pxQWMBPRPYxIJfhzWNdME7ts4ACsofi/S1invejvTdbPLBhwpgAWDw== X-Received: by 2002:a17:907:3e9b:b0:ab3:a18e:c8b6 with SMTP id a640c23a62f3a-ab75d2603e3mr346020366b.10.1738760332641; Wed, 05 Feb 2025 04:58:52 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ab6e47cf8bfsm1089049766b.40.2025.02.05.04.58.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Feb 2025 04:58:52 -0800 (PST) Message-ID: <565c5dee0aad4cc13d47189d42d59260151d365f.camel@cybertec.at> Subject: Re: Commit Latency From: Laurenz Albe To: Ramakrishna m , pgsql-general@lists.postgresql.org Cc: ravisql09@gmail.com Date: Wed, 05 Feb 2025 13:58:51 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-02-05 at 15:48 +0530, Ramakrishna m wrote: > I=E2=80=99m noticing commit latency of around 200ms for 1% of transaction= s, occasionally > spiking to 1 second. Since there is no significant I/O pressure, I=E2=80= =99m trying to > identify what else might be causing this in PostgreSQL 16. https://www.cybertec-postgresql.com/en/why-do-i-have-a-slow-commit-in-postg= resql/ Yours, Laurenz Albe