MIME-Version: 1.0
References: 
 <CAJk5AtbaQYshqms+AnVn0A_BOHFjfYhdEaAsLGWf0zVnA_5N7Q@mail.gmail.com>
 <469228369.58843.1759786683881@mail.yahoo.com>
 <CAJk5AtbeY+O71bbESq1+rG3zqv=mPzEDaxMniXuBfjZ7+RKpaw@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtbeY+O71bbESq1+rG3zqv=mPzEDaxMniXuBfjZ7+RKpaw@mail.gmail.com>
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Tue, 7 Oct 2025 10:24:51 +0530
Message-ID: 
 <CAJk5Ata7Kz-k=KfEyZVhckVgrk8_faNgGd3RcRnV2tzqs_D5ig@mail.gmail.com>
Subject: Re: Wal_keep_size
To: Thomas Carroll <tomfecarroll@yahoo.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000007fdaa06408a5f2d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5Ata7Kz-k%3DKfEyZVhckVgrk8_faNgGd3RcRnV2tzqs_D5ig%40mail.gmail.com>
Precedence: bulk

--00000000000007fdaa06408a5f2d
Content-Type: text/plain; charset="UTF-8"

Note archive mode is enabled.

On Tue, 7 Oct 2025, 10:22 Raj, <rajeshkumar.dba09@gmail.com> wrote:

> If wal_keep_size is more than max_wal_size wouldn't it always trigger
> checkpoint ?
>
> On Tue, 7 Oct 2025, 03:08 Thomas Carroll, <tomfecarroll@yahoo.com> wrote:
>
>> Hope nobody minds me chipping in here.
>>
>> The answer is "not necessarily."  The names make them seem closely
>> related, but not so much.
>>
>> max_wal_size is all about *checkpoints*.  When the WAL exceeds this,
>> Postgres will try to run a checkpoint.  Under some circumstances it won't,
>> but let's keep it simple for now.
>>
>> wal_keep_size is all about *replication*.  Replicas need WAL files to
>> stick around for long enough that they can process them.  wal_keep_size is
>> a minimum figure.
>>
>> Tom
>> On Monday, October 6, 2025 at 03:51:17 PM EDT, Raj <
>> rajeshkumar.dba09@gmail.com> wrote:
>>
>>
>> Should Wal_keep_size <= max_wal_size ?
>>
>

--00000000000007fdaa06408a5f2d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Note archive mode is enabled.</div><br><div class=3D"gmai=
l_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, 7 Oct 2025, 10:22 Raj, &lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com"=
>rajeshkumar.dba09@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"auto">If wal_keep_size is more than max_wal_size would=
n&#39;t it always trigger checkpoint ?</div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Tue, 7 Oct 2025, 03:08 Thomas Carr=
oll, &lt;<a href=3D"mailto:tomfecarroll@yahoo.com" target=3D"_blank" rel=3D=
"noreferrer">tomfecarroll@yahoo.com</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex"><div><div style=3D"font-family:Helvetica Neue,Helvetica,Ari=
al,sans-serif;font-size:16px"><div></div>
        <div dir=3D"ltr">Hope nobody minds me chipping in here.</div><div d=
ir=3D"ltr"><br></div><div dir=3D"ltr">The answer is &quot;not necessarily.&=
quot;=C2=A0 The names make them seem closely related, but not so much.</div=
><div dir=3D"ltr"><br></div><div dir=3D"ltr">max_wal_size is all about <i>c=
heckpoints</i>.=C2=A0 When the WAL exceeds this, Postgres will try to run a=
 checkpoint.=C2=A0 Under some circumstances it won&#39;t, but let&#39;s kee=
p it simple for now.</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">wal_k=
eep_size is all about <i>replication</i>.=C2=A0 Replicas need WAL files to =
stick around for long enough that they can process them.=C2=A0 wal_keep_siz=
e is a minimum figure.</div><div><br></div><div dir=3D"ltr">Tom</div>
       =20
        </div><div id=3D"m_-2462565561350107967m_4186013837168157399yahoo_q=
uoted_0479540014">
            <div style=3D"font-family:&#39;Helvetica Neue&#39;,Helvetica,Ar=
ial,sans-serif;font-size:13px;color:#26282a">
               =20
                <div>
                        On Monday, October 6, 2025 at 03:51:17 PM EDT, Raj =
&lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com" rel=3D"noreferrer norefe=
rrer" target=3D"_blank">rajeshkumar.dba09@gmail.com</a>&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div id=3D"m_-2462565561350107967m_4186013837168157399=
yiv6056229186"><div>Should Wal_keep_size &lt;=3D max_wal_size ?</div>
</div></div>
            </div>
        </div></div></blockquote></div>
</blockquote></div>

--00000000000007fdaa06408a5f2d--