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.96) (envelope-from ) id 1w54pL-002rul-1Q for pgsql-novice@arkaria.postgresql.org; Tue, 24 Mar 2026 16:41:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w54pI-007yhX-2K for pgsql-novice@arkaria.postgresql.org; Tue, 24 Mar 2026 16:41:57 +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.96) (envelope-from ) id 1w54pI-007yhP-1K for pgsql-novice@lists.postgresql.org; Tue, 24 Mar 2026 16:41:56 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w54pG-00000000ou5-3Omd for pgsql-novice@lists.postgresql.org; Tue, 24 Mar 2026 16:41:55 +0000 Received: by mail-wm1-x331.google.com with SMTP id 5b1f17b1804b1-486b9675d36so46057895e9.0 for ; Tue, 24 Mar 2026 09:41:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1774370512; x=1774975312; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Qwus2UgoqJw4bYcnyKpHOmCZV6A6gu4WYAXuLiBJdVg=; b=jP4ohsOF1LzghUpIuqFNyBcw9+iSG+1kHvO50wUrnFtOf6YsOfGPmfp/nrdZHAkE59 vX/l86sF9tzxLbxfe6KVhHwJFtySsbKwhyV9T5yp+38kBaw+a4HwOTWNwX6yaO4Rs5mx FL1aqjkMjQruucn/TNPYMADLQy66DWs5fKj6ZuAmaY9+xwwgZYRIBuMeliHxygrJbgAs x6C+czC88nQTXxrMSw+dD0hfAhnd8FK8zmvstg9G7rzRLrx0QWNqQsoxLKYjr3EWh8mz +f57u3azk/XgnWg0uiqIuBnh4DQ/Cv8SrVisP4BJr4ZzQuF7ZUR7zV/lDTFq7iTBwQ9z kBPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774370512; x=1774975312; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Qwus2UgoqJw4bYcnyKpHOmCZV6A6gu4WYAXuLiBJdVg=; b=WFJNWvBDEDSEdH1wCVFUhbVcr+sKajXbOIvArz3tnh6AdMAcE1jtzMoDu7u4oYHgAC KKzX4smgGa6o6rRZWfyiqNNuf5kMPLycfnjA+1Frkszka0aC+Zhzx5CWd2poH3NIa0Vk pr2pHirw8IPQEN+Wx4Nnxm7F+WiCBQm/H6xf1kZDvhY+dWWCqrVHzjBqpiYBStI97kxP nWCjr3+MMauc3T4tO8TiQ5UP8OYgQyJm5vjADYtzyk2Og7etftWWRoHUOKFzfCATKI3v mF7g1Yoij/0ciz9Ktri6kzgiWow9RCsJ2TOEoNFysbv5Yd03kT+/TrLVW8K1NW6INFpr V9Ag== X-Forwarded-Encrypted: i=1; AJvYcCU1OoFcI9LCV09BO3TP2YYz218+MSPgzIWO72pz+ii2JzSbJwKIEFCUpRjASPwolIFwrt3KuYxizJsw/HI=@lists.postgresql.org X-Gm-Message-State: AOJu0Yz5vss7yXMhstVB5En+QsENMufoJscaBUyEGUwL5QBn3U5n7Epp +3ZJyZr4GCLq/fi9hU9jRYgKT71WyDFrBlC4CgrECYTArZHpca2L18fR2vwWGNYh+AgjbgkpkFh YpZdV X-Gm-Gg: ATEYQzwtvUYFzEhCsUIw89WbdasY0J+iyAsirt4PVNtrQptrkMPQqn2lNmg3UjDPN44 cUI2mYyZ+oYTicPuOpW239qjA5UXtRzxKwcx248s+uKKJ0+ZvNUdrI7LSBfMf+Ib0NYrs5ZiyPP SkhkHqhBfz6dLk/COVvh3xw3hk07xWq2M7LF34VkSYHgqMZkE6lphoL3KupZSwWWK61aM+YRHey 4EzSWWyC0EUB86z1EmV+WX38PSqQ+31SUY4dPxGUZLYaOVH6Fnxz7qtEC1oiHtq+uEy5jDSmqoS FSYY9DJYWk9KI4SuWmWq5zicv0jyE7GO7YwpDzscyW6+Zq/gFn5uwUUaqPWoSMMdHUKAs8tt7ho wOex8xDYv/5N9udS7zio3uUf4X+fTwlOadljPPkRV5E+uDVEq5pISbMPeqIenYqPa0sAxTplm2y bgmcYWOxkdoTk25mmtyClrPGyb/i26Y+/C7rflrHfJPSoZov/6C5xqSA== X-Received: by 2002:a05:600c:3b12:b0:485:419c:4eba with SMTP id 5b1f17b1804b1-48715fc3286mr7062005e9.1.1774370512108; Tue, 24 Mar 2026 09:41:52 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:6701:8e0c:e727:4b64:3a9c]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43b64703c27sm39229925f8f.18.2026.03.24.09.41.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Mar 2026 09:41:51 -0700 (PDT) Message-ID: <2fb6a2f5eb2c9a1cbe701a237c74223d121ca918.camel@cybertec.at> Subject: Re: Replication Testing- How to introduce a Lag From: Laurenz Albe To: "Subramanian,Ramachandran" , "pgsql-novice@lists.postgresql.org" Date: Tue, 24 Mar 2026 17:41:51 +0100 In-Reply-To: <39ec6185a893473aa9217520e5a92be7@alte-leipziger.de> References: <8b38fa5141905f9ad6983b8d5ae944e812e3d28a.camel@cybertec.at> <0e00fcc0062b59b88f98dba4900ce49d5a9a3fea.camel@cybertec.at> <477369bf897b44feb2d2368f6fca93fc@alte-leipziger.de> <89d63402747edb3bf80ff668fdd63cc77334f446.camel@cybertec.at> <013104103e016e84d59c1e2accb0b1b1f99d9870.camel@cybertec.at> <39ec6185a893473aa9217520e5a92be7@alte-leipziger.de> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2026-03-24 at 07:51 +0000, Subramanian,Ramachandran wrote: > 3. If not caught up, how many bytes / KB worth of data needs to be replic= ated Please define "caught up", in particular how you understand the term in the presence of recovery_min_apply_delay, which you said you are setting= . The point of the parameter is to *prevent* WAL replay from catching up. Yours, Laurenz Albe