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