wal segment size

Colin 't Hart <colinthart@gmail.com>

From: "Colin 't Hart" <colinthart@gmail.com>
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2025-12-17T15:13:37Z
Lists: pgsql-general
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.

Would we gain anything by bumping the WAL segment size?

Thanks,

Colin