Re: explosive WAL growth - Mailing list pgsql-admin

From Scott Ribe
Subject Re: explosive WAL growth
Date
Msg-id 1334AE42-2DBF-4DA5-8F7B-529013796F55@elevated-dev.com
Whole thread Raw
In response to Re: explosive WAL growth  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: explosive WAL growth
List pgsql-admin
Found it. Kubernetes cronjob task.

> On Feb 27, 2024, at 11:22 AM, Alvaro Herrera <alvherre@alvh.no-ip.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 ;-)


pgsql-admin by date:

Previous
From: Lucio Chiessi
Date:
Subject: Re: explosive WAL growth
Next
From: Karthik Yellapragada
Date:
Subject: Re: explosive WAL growth