Request a Demo
Home   >   mailing lists

Re: wal segment size - Mailing list pgsql-general

From Ron Johnson
Subject Re: wal segment size
Date
Msg-id CANzqJaDiBmsLZSvr4hHFOEFKrN_J8jCLx4At9TUz64SzZ5K0DA@mail.gmail.com
Whole thread Raw
In response to wal segment size  ("Colin 't Hart" <colinthart@gmail.com>)
List pgsql-general
Tree view
On Wed, Dec 17, 2025 at 10:13 AM Colin 't Hart <colinthart@gmail.com> 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.

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

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: wal segment size
Next
From: "Colin 't Hart"
Date:
Subject: Re: wal segment size