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
Karthik Yellapragada
+1 860 830 5235
В списке pgsql-admin по дате отправления: