Re: explosive WAL growth - Mailing list pgsql-admin

From Karthik Yellapragada
Subject Re: explosive WAL growth
Date
Msg-id CACXtxt8X=UkJvdawDuaaOFmPeKQcNnzFgH7xuf=FYOvCstup3Q@mail.gmail.com
Whole thread Raw
In response to Re: explosive WAL growth  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: explosive WAL growth
List pgsql-admin
Just out of curiosity, what was the job doing?

On Tue, Feb 27, 2024 at 10:49 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
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 ;-)

--
Thanks & Regards
Karthik Yellapragada
+1 860 830 5235

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: explosive WAL growth
Next
From: Scott Ribe
Date:
Subject: Re: explosive WAL growth