Re: explosive WAL growth

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: explosive WAL growth
Дата
Msg-id 1334AE42-2DBF-4DA5-8F7B-529013796F55@elevated-dev.com
обсуждение исходный текст
Ответ на Re: explosive WAL growth  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: explosive WAL growth  (Karthik Yellapragada <karthik.yellapragada@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Lucio Chiessi
Дата:
Сообщение: Re: explosive WAL growth
Следующее
От: Karthik Yellapragada
Дата:
Сообщение: Re: explosive WAL growth