From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: explosive WAL growth
Date: Tue, 27 Feb 2024 11:09:58 -0700
Message-ID: <C7733827-4E85-47AF-8D39-349D007E229A@elevated-dev.com> (raw)
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.
My next step might be to use something like pg_waldump to see what's in this WAL.
Any suggestions?
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
Subject: Re: explosive WAL growth
In-Reply-To: <C7733827-4E85-47AF-8D39-349D007E229A@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox