| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: wal segment size |
| Date: | 2025-12-17 15:28:00 |
| Message-ID: | CANzqJaDiBmsLZSvr4hHFOEFKrN_J8jCLx4At9TUz64SzZ5K0DA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 17, 2025 at 10:13 AM Colin 't Hart <colinthart(at)gmail(dot)com> wrote:
> 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.
>
One second to archive 16 measly MB seems really darned slow. Another vote
to *that* problem.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin 't Hart | 2025-12-17 16:10:19 | Re: wal segment size |
| Previous Message | Laurenz Albe | 2025-12-17 15:25:17 | Re: wal segment size |