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 1vOshc-00BD5c-1D for pgsql-novice@arkaria.postgresql.org; Fri, 28 Nov 2025 07:15:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOsha-009dYP-3D for pgsql-novice@arkaria.postgresql.org; Fri, 28 Nov 2025 07:15:35 +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 1vOsha-009dYG-2L for pgsql-novice@lists.postgresql.org; Fri, 28 Nov 2025 07:15:35 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vOshY-001sAL-2U for pgsql-novice@lists.postgresql.org; Fri, 28 Nov 2025 07:15:34 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-b7697e8b01aso309724066b.2 for ; Thu, 27 Nov 2025 23:15:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1764314132; x=1764918932; 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=RztegMGpNEO6m570+c4Ca4K7i3jpfqRJwrNRKHlp7rQ=; b=YPKqLTnYrYQEzQNCunAWzJmj9IsO9Zo9TJOKJOch0jhaGpCrh4UM0Hkg9MYksMUlo0 tM1PbnMFbndBu63JtUGBpdO7QogZusA7nvldu/B9Pt0jHCKbT1Xzgcd0RBTx/qR8fM50 x16sTh/zo19i+I7nntv6kzSP+x/X7uu6twH7c++FKSnaGoOwWwkXenOy3FbtB9XesgkV mBV5na4egKdCHVbPPfnYApZxNlMtLXVg8QzAoeeICJZrXDzCruRXPyAZ+BYiyE/h05eM 0JTlUNPyixyjd3T7Dc7RrPM5tuNKRXdIjFaEBuAuenlYdB03y/7g5XuPMEMTsBmqPdQj xx5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764314132; x=1764918932; 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=RztegMGpNEO6m570+c4Ca4K7i3jpfqRJwrNRKHlp7rQ=; b=w0aTp4r+J2wjdPJKUKmXPmrNLoIR5zbVsmB/obYg4Q0xWx453xTljVz4u3qoR1Bgrn x6xXrFImOTy3Jv6FQ/ER+KYHsnpCHJ3tdFX2Gouv0JqBdKRgTC+8WE53ognfmF6Kkn7Q u6I+MLNCddmluReWAhzJqMT15+RCUtxR05LwOQEFKWW6zBk0hBM/OUKuv6bXqTvoDm8d HcNxTaFg3VqUHw7enY95Fm6hY5ofXq00taNF9oR1BioF8tZi5xCouzwXWZZDyDa/SEzM pQt9ob7JQ27g9nzSxx2s41Uv1n2HGhq0dsB+JHUYvHbLeiu3nZKvU2HeLdjBR0503XBn LdMg== X-Forwarded-Encrypted: i=1; AJvYcCW/io7dVX14Di3nZJlo9rFGN7EzPL9MH1HftfJMmZbQn/26iWgAxBwSbLoRwyOkbNB37CCMuWoNbstBuPQ=@lists.postgresql.org X-Gm-Message-State: AOJu0YzsztMRgtYE9b1OI1m5CkC8UIGBh0Rm1JvYApjsawH3opbVIDgY 0bpDX8npLTmDUd62jnzuTO8CbS4PGtYYknlTnKF5uF9L4D/qFW4Pc7rb7pqtMB1Xg3M= X-Gm-Gg: ASbGncs32uF3AP3SH/G622zQbanKRCDfPktRfuajw20XDUy7Zp32kV6rybg3Ucq76l9 5H3IocOgmii9F9YhknK74pQEmz2kf79KpTpEC4JzuZBv/hxByuCcnzwHV3SMIar0aky2tZMyQKx TUPlpZdgHxgpqa4qHizoUMtEpbN7naXMQfwi8zvLAk33KAiW55e0TRC5KdRkWuLDQx5B5Ja9lVz aS9Zv8E4mJdoiyOlAo6I7K+JRhzXMA9Dg7ztcUCnkHutTCQFftmcSykZfYpZQ9VxLfs3bRJXthn CT3u8IGDHJ8HKWyrEHrKSeJWFsRhpoeoWn7KGcpGgak9jpCKI42Ai/dR9/D6Kg8wTW1jiQ9sIMJ QnDv3q+3cJ7kzVdbNFEysCkM58wsIq1XXFgVUV57vcn8wlClC4CJloI68j+CBOUgx9+4ExbXDul DtUdIV0Eiymu6ytARXwRhgEcKlIUU7FOmzx+FVHkgY X-Google-Smtp-Source: AGHT+IEZhwJ/lawCKUfHbRcOQFRHLTD1uHfPn0ZuiJ8jMPlLmkON9Nzi3tZW0/tFPAC7gY7Y741wgA== X-Received: by 2002:a17:907:3d8b:b0:b72:5e2c:9e97 with SMTP id a640c23a62f3a-b76716db44bmr319652766b.36.1764314131903; Thu, 27 Nov 2025 23:15:31 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:1ce:374:d99c:26de:53b0]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b76f59a6a67sm365458066b.34.2025.11.27.23.15.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Nov 2025 23:15:31 -0800 (PST) Message-ID: <4172b7bc435b7d5dd3205500514f6871be80448b.camel@cybertec.at> Subject: Re: AW: how long should Archive logs be retained From: Laurenz Albe To: "Subramanian,Ramachandran" , "pgsql-novice@lists.postgresql.org" Date: Fri, 28 Nov 2025 08:15:31 +0100 In-Reply-To: <69896b79eb2a4bf09ed3713dbe825288@alte-leipziger.de> References: <1f12660d233efc644edb6a23c7bd4bcc84b503af.camel@cybertec.at> <329482d836f34a548d071aab63961f11@alte-leipziger.de> <070dbb3e6b4f41c39e41f5f2979ee4a9@alte-leipziger.de> <69896b79eb2a4bf09ed3713dbe825288@alte-leipziger.de> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-11-28 at 05:28 +0000, Subramanian,Ramachandran wrote: > Each transaction has it's own private copy of the data it is interested i= n, > and each private copy of the data has it's unique transaction number asso= ciated > with it. A snapshot is not a copy of the data. It is the list of transaction IDs th= at are visible and the ones that are not. That snapshot determines which of t= he data in the database you can see. Yours, Laurenz Albe