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.98.2) (envelope-from ) id 1xIVsw-00000003jh2-1TRg for pgsql-general@arkaria.postgresql.org; Sun, 18 Oct 2026 18:45:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xIVsv-00000003lxD-1UBB for pgsql-general@arkaria.postgresql.org; Sun, 18 Oct 2026 18:45:29 +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.98.2) (envelope-from ) id 1xIVsv-00000003lx4-0CTV for pgsql-general@lists.postgresql.org; Sun, 18 Oct 2026 18:45:29 +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.98.2) (envelope-from ) id 1xIVst-00000002qb6-09o1 for pgsql-general@lists.postgresql.org; Sun, 18 Oct 2026 18:45:28 +0000 Received: by mail-wr1-x42f.google.com with SMTP id ffacd0b85a97d-48e00eee27dso666856f8f.0 for ; Sun, 18 Oct 2026 11:45:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1792349126; x=1792953926; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to:content-type; bh=0QmvXlFMLfgjIlLSy6IIe2ZMrOKxmBhVRdRlFqYbmY0=; b=diN+TmRT/IB5LnQF2f3LomyBpWY7hAKMGUxLPX0IwFbVGUU7AnYUvxLZeAT97Q7diI 227SENZ9BT7W8d8HLWrcrIVWVqcRZX4Xr7mQTd8D69bTmvFvuE5UWcgnKjU31Bm91pg0 r72JbDpGq9eU7pBvJv6wLdY6B99ZZEOHY4msZbjOHGFD127tJiPfVGk6qbJeRqqVp+xn tqi4REaoOylKgPopFriR0xQs0g7OeQzLOXL2bA+dWNc32SORnWSOSmC2j2AuZlmuASXA elFuQ1MrJyeThFotmHWuD2ha5vXuxUnaV09HeLY5ONpcwLedOJcz9+dT8ybM7DOkM+P3 V+CA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1792349126; x=1792953926; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=0QmvXlFMLfgjIlLSy6IIe2ZMrOKxmBhVRdRlFqYbmY0=; b=DSE9X9KIUdkrCFKH6xHHtJ9H3bVXeKV7QPxdnRxCV6V5Cc+YbgNT1AFhyC2pwpWfVN JAp41TZlgVP04h0A0xDwi56WkQxYiQWuQUBf8d99SRtlRW3/a7qEaOCzCLdjgZS9+DoV tndYY40JPO8qt/KDmsmM14cv77AkClP6DQ96z1MkiO29cxHgS6jmSDAU1qyd8b2lSebF D62SmyXrw7DyyA4GsjbpUWQA98HDbTos5DKipijFywqNxn/BJk1gdeSj5Yw5iTfO4rl1 7H0cXk5oXx3kRQc1qutJffzIR9qI1NrgivSYVwHhqLMZkCQfyGlHvN7U7WSkd0IAHd6q 1u3w== X-Gm-Message-State: AFq9FYKq4a3ViaQzVajuCwnUFqN2gTFjXucYW5Orh2DoJF6XdTar/rMu L/xG75vJMCjNlQ8N83LnpEgiHGVlWmUZgFVWZe2mnP4upCUGgZ3yeYBit2TqXG//vXM= X-Gm-Gg: AYBFou3kwvY5nalezBsXuyyBdv+9h4n6i1lCf8HEgwj+irVxR+fMwAvpUeCyTxXcDjI gC+pWOIaLOlWVCo9vfhTPZ9vMfUxJqZV4MTaKNf73YuTvHZSO34WJCWpJN1z/MtPhQGD9LXQh8l Odb6pTpEFVFhp8IwBYETJmN6tLifmJ8i4PxyQoeOlZb4ytRAQSWadx1qcukl20SB2ogy2Y7dqdp aiB2satarCeo7PhnARD42xN5tbr1jPzYG+w7Xhc36OURud965HXhH+24pROpmlKymVbAdpdt5he 0F7C2yQTM9lzbcw04cttEJe7wVSiFn7re3FnazpHZwiPQ4/wBk7CfR+AvYgngk0T71hm5ISAGpW myTRCiqRuSrcX6ZN0QeQMzoNKSeB/+oNSLv+4LxHf9E9sIzXIepCs71LEjNNGCtA/e/aCXf7yls N1LpoxnWxqUgnG88fVO0EIvpZ0TevMuFdTsZLAGDUomMMw68W6k5637IK2q1AvE6pzdsg3npvQ7 aUm+eheGcgiGFrs9Pf1vb0n1B+fU68= X-Received: by 2002:a05:6000:29d2:b0:48c:7386:af18 with SMTP id ffacd0b85a97d-48e079803d2mr6876612f8f.8.1792349125970; Sun, 18 Oct 2026 11:45:25 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:b677:677f:591c:a18a:2956]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-48dfd4c575esm16137187f8f.10.2026.10.18.11.45.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 18 Oct 2026 11:45:25 -0700 (PDT) Message-ID: <03f09ff7d28decc50b84ec2b4d697b7a0d8f0dc3.camel@cybertec.at> Subject: Re: Regarding huge logical slot lag between source and target From: Laurenz Albe To: Durgamahesh Manne Cc: pgsql-general , PostgreSQL mailing lists Date: Sun, 18 Oct 2026 20:45:25 +0200 In-Reply-To: References: <28a109ddf0ecc56465676a878565acb29d225709.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2026-10-18 at 23:16 +0530, Durgamahesh Manne wrote: > Hi what is the formula to set this logical_decoding_work_mem? >=20 > I set 4Gb=C2=A0 > When we have huge DML ops what value can be recommended. >=20 > Ram 128gb=C2=A0 I don't think there is a formula, but 4GB is pretty high. Can you be a bit more specific about the "huge DML operations"? Yours, Laurenz Albe