MIME-Version: 1.0
References: <CAMon-aQ8X7H7jCC6ggKm9Uzcu3KfGVC34RRqKt8BCfpDn2tq9A@mail.gmail.com>
In-Reply-To: <CAMon-aQ8X7H7jCC6ggKm9Uzcu3KfGVC34RRqKt8BCfpDn2tq9A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 17 Dec 2025 10:28:00 -0500
Message-ID: <CANzqJaDiBmsLZSvr4hHFOEFKrN_J8jCLx4At9TUz64SzZ5K0DA@mail.gmail.com>
Subject: Re: wal segment size
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f594930646277da2"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDiBmsLZSvr4hHFOEFKrN_J8jCLx4At9TUz64SzZ5K0DA%40mail.gmail.com>
Precedence: bulk

--000000000000f594930646277da2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Dec 17, 2025 at 10:13=E2=80=AFAM Colin 't Hart <colinthart@gmail.co=
m> wrote:

> Hi,
>
> I see very little advice on tuning WAL segment size.
>
> One of my clients has a few datawarehouses at around 8 - 16 TB
>
> On one of the nodes there are approx 15000 WAL segments of 16MB each,
> totalling approx 230GB. The archiver is archiving approx one per second, =
so
> approx 4 hours to clear.
>

One second to archive 16 measly MB seems really darned slow.  Another vote
to *that* problem.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Dec 17, 2025 at 10:13=E2=80=AFAM =
Colin &#39;t Hart &lt;<a href=3D"mailto:colinthart@gmail.com">colinthart@gm=
ail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>H=
i,</div><div><br></div><div>I see very little advice on tuning WAL=C2=A0seg=
ment=C2=A0size.</div><div><br></div><div>One of my clients has a few datawa=
rehouses=C2=A0at around 8 - 16 TB</div><div><br></div><div>On one of the no=
des there are approx 15000 WAL segments of 16MB each, totalling approx 230G=
B. The archiver is archiving approx one per second, so approx 4 hours to cl=
ear.</div></div></blockquote><div>=C2=A0</div></div><div>One second to arch=
ive 16 measly MB seems really darned slow.=C2=A0 Another vote to <i>that</i=
>=C2=A0problem.</div><div><br></div><span class=3D"gmail_signature_prefix">=
-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">D=
eath to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m =
still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div>=
</div></div>

--000000000000f594930646277da2--