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/
