wal segment size

From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: wal segment size
Date: 2025-12-17 15:13:37
Message-ID: CAMon-aQ8X7H7jCC6ggKm9Uzcu3KfGVC34RRqKt8BCfpDn2tq9A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-12-17 15:24:32 Re: Record last SELECT on a row?
Previous Message David G. Johnston 2025-12-17 13:26:20 Re: Record last SELECT on a row?