Re: explosive WAL growth

Поиск
Список
Период
Сортировка
От Karthik Yellapragada
Тема Re: explosive WAL growth
Дата
Msg-id CACXtxt8X=UkJvdawDuaaOFmPeKQcNnzFgH7xuf=FYOvCstup3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: explosive WAL growth  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: explosive WAL growth
Список 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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: explosive WAL growth
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: explosive WAL growth