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 1u5jab-0050bE-Oj for pgsql-admin@arkaria.postgresql.org; Fri, 18 Apr 2025 11:08:58 +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 1u5jaZ-00C7rA-OO for pgsql-admin@arkaria.postgresql.org; Fri, 18 Apr 2025 11:08:56 +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 1u5jaZ-00C7qv-Bf for pgsql-admin@lists.postgresql.org; Fri, 18 Apr 2025 11:08:56 +0000 Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5jaW-000jMS-2N for pgsql-admin@postgresql.org; Fri, 18 Apr 2025 11:08:55 +0000 Received: by mail-wr1-x42f.google.com with SMTP id ffacd0b85a97d-39c1ef4acf2so1105272f8f.0 for ; Fri, 18 Apr 2025 04:08:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1744974532; x=1745579332; darn=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=b9APN0EhgufrTGPZ5SHLIFnU8RJ3Pk0Su/FRtfkMnNQ=; b=MuRDq1z3q6gi2F8f7rVE6JFn1sPuW9p58qD9uVj+l8kAM1h2t3DOZ5RI0WAmczJ/Ni +yuzQpHt0ITVyVBmY0tzTbyIHmvFKdlKS4p6hm3QjL/XhqbHHKCEQrnXxJNmRhJnCYpS dt3aJsBf5KgdfoCeQFrDakKUvDW6k2ly6xm9cufzhx+V/ttWqzttAX9JGtakNBBnL4L3 h4VxXwJM5AqJj4Dl0aSE4J8+L8Yj5LaFnaux3XK+XfY+aZmBPP43OMBTjnZYOVInWcjv buyHzTSxgAF4v0xQIU6MFmOLqircsXhMt0ZJvN0xquHV8as/DGwm7xG8/FXFwrxsaaUa g5wQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744974532; x=1745579332; 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=b9APN0EhgufrTGPZ5SHLIFnU8RJ3Pk0Su/FRtfkMnNQ=; b=YOiSVXMx1G47WVPNDorm1CPZCVHMd44s8z9MF8aSQwOEoLxOC/qQjHDkTXQDF/NPIM QoksqkgrxISw4LgMmydTGHlJrxzDqG68MMrSYSGO6bIExy6Kw/sX7NxwHXjU4LQpSUQP HtZLhOPGEZyoLu6u6lPSVdUcqQZj8xtDTE9d1mPlcXKfW0E2X6S6V2BEyu4Y3Dj1cJ3m GIRUyxi+a13kyv7Co3VYWsb2BWqnk2sM/CKkov2gGKUfRWdiIgAPnBzv0qoU67BPBkY+ rwzqgChyAHlcScUetVvtRtg8SggYTg4T+sWB6KG3kpcClo4y2vV7G1ZTs0rN86cdaj6c ZHeg== X-Forwarded-Encrypted: i=1; AJvYcCWIPk92DezmDn55F+s8rtuUmCtRFfDuAZgRFlRfuKwn/diWmRl3T9wJY2dXJ2B5wU444ruNyilmbveDYw==@postgresql.org X-Gm-Message-State: AOJu0YxK1/L9ixfR6oipbcQ9bhAMsh0iuCEuXZJqoXTjXq1FhUBrrMdz 39xNCgNV3zy7sb5PBf/42d/a/4Xm43OccojEY7t8EV0SdwtpC0ui8bhhT8+sISc= X-Gm-Gg: ASbGncsm48A04J71eBd/JZnmSqAFX6XJC+c9YmCBKq2qK/AmKwCeHp7yBcO+Kr39X2u QJHMGWe/YtEhq6xPlp0ztDfUyKJ/VToX/ibpuGj+X4AU10i0/+cjkEh8HBIbrj5DESjnL/FppN1 5SATADJ73leVULEr4Zz4p5L34qUc9bFZW9pYqkRcoBRJLGdHQ+aGDBt4nwgt51VBYFi9w7zGXRm vy/U8no8erllsly+UCtfuLq3uE44e4bXDAhJs6hzFl/Eomi9GbOYYpo1wHstpWlBZ5NpB7ziOWm qN2u6vzdsl+5DzUokNt8eFCd72NSn2cpBIo3N1hK0fK1NsLWqmxaJ09ijSVP X-Google-Smtp-Source: AGHT+IFQppZnEWNvUUrwvRnfeMJ3882DaII1UR7A2X/g1NY7CT8TouVHhdAZxUbMFVjW32OLkpZlHw== X-Received: by 2002:a5d:64ae:0:b0:391:ba6:c066 with SMTP id ffacd0b85a97d-39efba5dba8mr1993610f8f.35.1744974531609; Fri, 18 Apr 2025 04:08:51 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:5373:9d9a:af04:78c5:75aa]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-39efa493446sm2417870f8f.74.2025.04.18.04.08.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Apr 2025 04:08:51 -0700 (PDT) Message-ID: <6e85abdb00db4ec0cd8220373b4610838d8a3455.camel@cybertec.at> Subject: Re: Replication lag From: Laurenz Albe To: Wasim Devale Cc: "Gaspare Boscarino, P.Eng." , Pgsql-admin , pgsql-admin Date: Fri, 18 Apr 2025 13:08:50 +0200 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 Fri, 2025-04-18 at 16:21 +0530, Wasim Devale wrote: > So finally long running on a replica won't minimise replication lag to ze= ro in any scenario? Correct? I am not sure I understand that sentence correctly. Yes, if you are running long-running queries on a standby server, that won't minimize replication lag. But I am surprised that anyone could imagine it would. Yours, Laurenz Albe