| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: explosive WAL growth |
| Date: | 2024-02-27 18:22:17 |
| Message-ID: | 202402271822.t4vbqds7mjge@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 2024-Feb-27, Scott Ribe wrote:
> Something is causing our WAL to grow 160GB/hour *faster* than archiving. (Archiving appears to be working normally.) This started in the past couple of days.
>
> I am having some trouble finding the cause of this. I am looking at pg_stat_statements, # calls, time, shared blocks written. I am also looking at recent client app deployments.
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.
Some backup tools implement parallel archiving of WAL files, which helps
you deal with massive accumulation of them.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucio Chiessi | 2024-02-27 18:22:18 | Re: explosive WAL growth |
| Previous Message | Scott Ribe | 2024-02-27 18:09:58 | explosive WAL growth |