public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Colin 't Hart <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: PostgreSQL General <[email protected]>
Subject: Re: wal segment size
Date: Wed, 17 Dec 2025 12:21:03 -0500
Message-ID: <CAKAnmm+yoNEQCV3qXceXm9rNoOAPYK0DQCpSqLkNGvGuOQ3W=A@mail.gmail.com> (raw)
In-Reply-To: <CAMon-aSkPs=N5GHJsOzLs5RKcrba3=ng_6HUEKZy1=1GJgCEqg@mail.gmail.com>
References: <CAMon-aQ8X7H7jCC6ggKm9Uzcu3KfGVC34RRqKt8BCfpDn2tq9A@mail.gmail.com>
<[email protected]>
<CAMon-aSkPs=N5GHJsOzLs5RKcrba3=ng_6HUEKZy1=1GJgCEqg@mail.gmail.com>
On Wed, Dec 17, 2025 at 11:10 AM Colin 't Hart <[email protected]> wrote:
> Thanks Laurenz, that confirms what I was assuming. Archiving is via
> pgbackrest to a backup server, over SSH. Approx 750ms to archive each
> segment is crazy -- I'll check compression parameters too.
>
Switch to archive-async = on. When doing that, the typical time drops to
10ms or less. Also use a compress-type of lz4 or zst, which perform way
better than the default gz. If you are encrypting, that's a bottleneck you
just have to deal with, no shortcuts there. :)
tl;dr try other things before messing with the WAL size. The current size
can work very well even on very large and very, very busy systems.
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: wal segment size
In-Reply-To: <CAKAnmm+yoNEQCV3qXceXm9rNoOAPYK0DQCpSqLkNGvGuOQ3W=A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox