MIME-Version: 1.0
References: <CAAccyYKpNsQMD+S-A7a8YtDevFN0uRXkzg4tYWWBOFsv_jASNg@mail.gmail.com>
 <fd5c6708-3791-4339-83a2-e5fc389cd9cb@aklaver.com> <CAAccyYLYZmwQiNMoJcQgo5t+E24rDtu1ZeBUrER7ZTKNAcZesw@mail.gmail.com>
 <d3622bf1-6a62-4703-b14e-295f47b5e348@aklaver.com> <CAAccyYJ-07SzCRAEkGJ2Qa8EAPCHQM4qcpB=OvD8P0zDbCJ0KQ@mail.gmail.com>
 <73f3723b-f279-43c6-884d-d12b3151ec9e@aklaver.com> <CACd=f9c9MZUhjGc9hKZL=7S18LkxwW_LDsiH15wmUAO-ERkXxg@mail.gmail.com>
 <bc2198fe-cf6a-47b2-bae9-a694c2097bb3@aklaver.com>
In-Reply-To: <bc2198fe-cf6a-47b2-bae9-a694c2097bb3@aklaver.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 15 Aug 2025 12:40:18 -0400
Message-ID: <CAKAnmmLgGRZsLH7crTHmr5DCpdz-FnLy7kwCsa-wJ83Q948iew@mail.gmail.com>
Subject: Re: Questions about the continuity of WAL archiving
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Bob Jolliffe <bobjolliffe@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000bf6bf6063c6a0d07"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLgGRZsLH7crTHmr5DCpdz-FnLy7kwCsa-wJ83Q948iew%40mail.gmail.com>
Precedence: bulk

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

On Tue, Aug 12, 2025 at 3:20=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> File creation time in S3 is relatively slow so backup/restore
> performance is improved by enabling file bundling.
>

Just to be clear for the archives, pgbackrest's file bundling only applies
to backups, not to WAL, which is the OP is dealing with here.

Pixian Shi, what sort of WAL volume are we dealing with? (in WALs generated
per minute)

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Aug 12, 2025 at 3:20=E2=80=AFPM A=
drian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_cont=
ainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex">File creation time=
 in S3 is relatively slow so backup/restore <br>
performance is improved by enabling file bundling.<br></blockquote><div><br=
></div><div>Just to be clear for the archives, pgbackrest&#39;s file bundli=
ng only applies to backups, not to WAL, which is the OP is dealing with her=
e.</div><div><br></div><div>Pixian Shi, what sort of WAL volume are we deal=
ing with? (in WALs generated per minute)</div><div><br></div><div>Cheers,</=
div></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>=
Greg</div><div><br></div><div>--</div><div>Crunchy Data - <a href=3D"https:=
//www.crunchydata.com" target=3D"_blank">https://www.crunchydata.com</a></d=
iv><div>Enterprise Postgres Software Products &amp; Tech Support</div><div>=
<br></div></div></div></div>

--000000000000bf6bf6063c6a0d07--