Re: explosive WAL growth

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: explosive WAL growth
Date: 2024-02-27 18:48:34
Message-ID: 1334AE42-2DBF-4DA5-8F7B-529013796F55@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Found it. Kubernetes cronjob task.

> On Feb 27, 2024, at 11:22 AM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
>
> It could be autovacuum processing large tables that haven't been
> processed in a long time, in emergency mode. This happens if you turn
> it off and do nothing to substitute it.

We have autovacuum on, and pretty well tuned.

> Some backup tools implement parallel archiving of WAL files, which helps
> you deal with massive accumulation of them.

We'll get that in an upgrade we're getting ready to deploy. Ironically, it might have just hidden this problem ;-)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karthik Yellapragada 2024-02-27 18:58:05 Re: explosive WAL growth
Previous Message Lucio Chiessi 2024-02-27 18:22:18 Re: explosive WAL growth