Request a Demo
Home   >   mailing lists

wal segment size - Mailing list pgsql-general

From Colin 't Hart
Subject wal segment size
Date
Msg-id CAMon-aQ8X7H7jCC6ggKm9Uzcu3KfGVC34RRqKt8BCfpDn2tq9A@mail.gmail.com
Whole thread Raw
Responses Re: wal segment size
Re: wal segment size
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Record last SELECT on a row?
Next
From: Ron Johnson
Date:
Subject: Re: Record last SELECT on a row?