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