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 1uUnQQ-008for-UF for pgsql-general@arkaria.postgresql.org; Thu, 26 Jun 2025 14:18:02 +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 1uUnQP-00DK4j-27 for pgsql-general@arkaria.postgresql.org; Thu, 26 Jun 2025 14:18:01 +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 1uUnQO-00DK4Q-NV for pgsql-general@lists.postgresql.org; Thu, 26 Jun 2025 14:18:01 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uUnQN-004EW9-0k for pgsql-general@lists.postgresql.org; Thu, 26 Jun 2025 14:18:01 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-60f276c7313so703334eaf.2 for ; Thu, 26 Jun 2025 07:17:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750947477; x=1751552277; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=KFVkA615a+pXB7EH52iGHhDLXK44Uldulx6Y7oHFpB0=; b=UnL3YCUxqT62gm56lXyxhm3JdMLYvOHw6rCGIXU2e7/JxZRF2x8hm3Dsr8kvK7mJSZ dxgKGihmJ5GPFQAwBmxnP50cZTlYEI5jSbb3xrS4VWjubv5lnJo/MjaFw4EOQge7TZkz 649fSEW4VAHs2lwUPmOJBNgahos6oLsL1l6QGmRyAx7ZWuZWOs+xvs2JVZLn2ExvEJsn OLxQaMa02U4Psz0BY2wAXeFITiyN4tgfxPs5dUUVxKRPWuBQJlIkXj6kr3Sqmjo/4GQE PpZulvhiC3/CM/nAz39sUWVmEnSCk/WqQP7gu98dxT7GgnRQFYkqphyuWDdBff8YF5BV KFcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750947477; x=1751552277; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=KFVkA615a+pXB7EH52iGHhDLXK44Uldulx6Y7oHFpB0=; b=Fbtu4/EZHZt05l6ngMFqkn20yVMmTK6Qu+Nc2BygnKdPOhsJqenSdJSEQZBkiBlnWZ Dz9c4vi3S3ywCOiOXBATp8q7DKib5i1LxGa2wbl5qXWWK8sFDZ/VCH6CFx4EtuLiB1Te Mfyb4ryvSiM4VUxmTpj/oROD6SlOKphbgtdDDN5xHAfOYo24rhZCABLCtri0PzJ7IP2y JsMrupyLZvhP6cUiES6KEOXg0JSFVBO7MR0NtXzCcbpnyzusXqOKuPNug3Gv2NqD6O6r gyDQDUcIlAAp0afjbOCOojB5vFk1G9aIdqlLC7+i5fkrmGC8WXXjPfov4YPc37RjWMdS ycpQ== X-Gm-Message-State: AOJu0YxiuiGCop3Ia0STOUD1rZSHx7lb5hTPBU6O4KxXkAVD8eF4njDy HhaKxCOvxREtdRJ8pJQMFMo0OjlQqTPRV6kMF17EsnTLkasICDjhU0igCgGgMw2t2riI7neikev 3k7OijF0GCK0XPb1FrkK8DwP7hzrWPF2NQNEC X-Gm-Gg: ASbGncsp/v0tSvnFb+YzcrZvpAIA5BwPdFdkjBcPnsB+sNkq4oVxMjEh7kkiJ9l0JOA DpEe3CPqRvxqaNc53BQ4iLBUMPcxENMeXCAL5kYwk2UckGNmxTVlw2qU+0xSNCzasoandUAOD9f Jl474EeEFWWUoVeS7aOJGRMcdxUHhdPDMfIH+9/aC+TSB/6j6Id3SBvqwXMGm8QCVRkD+tHNWlB oLq X-Google-Smtp-Source: AGHT+IGyFTNLxsatLWuMUObQG4KclSpHCruM3WPF25ZPfW862pRy09yDaAl38k55pmJ/7tVT/tvN1ZkU7w+YkMoMgaQ= X-Received: by 2002:a05:6820:1998:b0:611:9bc2:7cbd with SMTP id 006d021491bc7-6119d6a582emr5683778eaf.1.1750947477002; Thu, 26 Jun 2025 07:17:57 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:4104:b0:5d1:adff:a37f with HTTP; Thu, 26 Jun 2025 07:17:56 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Thu, 26 Jun 2025 07:17:56 -0700 X-Gm-Features: Ac12FXyVW8Om-jftxfcG8mDiO96rb4c0lHVbn5cxu0Ip86IijyUsuZRGXxLoGCI Message-ID: Subject: Re: Question about different behaviour in pg_wal when archive_mode is set on or off To: Arpad Kiss A Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000631d2406387a3a4e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000631d2406387a3a4e Content-Type: text/plain; charset="UTF-8" On Thursday, June 26, 2025, Arpad Kiss A wrote: > Can someone explain why the difference in behavior? Does postgres only use > the seqno only to differentiate the wal files here? Why does postgres not > rotate out files in the former case? > Seems like it is being helpful not throwing away data you may be experimenting with during a point-in-time recovery. David J. --000000000000631d2406387a3a4e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, June 26, 2025, Arpad Kiss A <arpad.a.kiss@est.tech> wrot= e:
Can someone explain why the differenc= e in behavior? Does postgres only use the seqno only to differentiate the w= al files here? Why does postgres not rotate out files in the former case?

Seems like it is bein= g helpful not throwing away data you may be experimenting with during a poi= nt-in-time recovery.

David J.

--000000000000631d2406387a3a4e--