Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rf1uC-00F0fn-DT for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2024 18:10:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rf1uB-004lNM-02 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2024 18:10:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rf1uA-004lND-FL for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2024 18:10:15 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rf1u7-001WVH-Cz for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2024 18:10:14 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 790FC6BD3F for ; Tue, 27 Feb 2024 18:10:09 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1709057409; bh=wcZsbcSWv1izge38pP8PLbN6F9GocEaEhVaD0LiItJw=; h=From:Subject:Date:To:From; b=5KD2HX7Z07uYHxq8Ip1257mJYQi33u6/IbPeFFYCNgt5hKKe5J3B2NWkXJNt+TpAA qohc5I2jD58G8GEoeA4HrM0qpalpSnX3+5gdgYaWja1yGbZh8tiEQfMRghnLKgw3UX 1Uqhj3VPd7hiBGgggsOKkAYsYumhYuncTCqC+LpBlRTZS4yWT1RswUVNpv3m6e5Mg2 ZDicC6fhS1X+8pZML+UoS0GE+4Zp5PlLg3h3ih0Spw/IvJGzA56aRuzopKswrhG8uH w6edAeP52TePBvp8fiRWTWr7HD7UY3r5xgq39mWSVVxL8BLNP52CH2EHu+am2ZvYTl wolQUxgwe7bHA== X-Virus-Scanned: Debian amavisd-new at emo09-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo09-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JIf-7Y9_jm3U for ; Tue, 27 Feb 2024 18:10:09 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 12C5B6CD14 for ; Tue, 27 Feb 2024 18:10:09 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1709057409; bh=wcZsbcSWv1izge38pP8PLbN6F9GocEaEhVaD0LiItJw=; h=From:Subject:Date:To:From; b=5KD2HX7Z07uYHxq8Ip1257mJYQi33u6/IbPeFFYCNgt5hKKe5J3B2NWkXJNt+TpAA qohc5I2jD58G8GEoeA4HrM0qpalpSnX3+5gdgYaWja1yGbZh8tiEQfMRghnLKgw3UX 1Uqhj3VPd7hiBGgggsOKkAYsYumhYuncTCqC+LpBlRTZS4yWT1RswUVNpv3m6e5Mg2 ZDicC6fhS1X+8pZML+UoS0GE+4Zp5PlLg3h3ih0Spw/IvJGzA56aRuzopKswrhG8uH w6edAeP52TePBvp8fiRWTWr7HD7UY3r5xgq39mWSVVxL8BLNP52CH2EHu+am2ZvYTl wolQUxgwe7bHA== From: Scott Ribe Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.400.31\)) Subject: explosive WAL growth Message-Id: Date: Tue, 27 Feb 2024 11:09:58 -0700 To: Pgsql-admin X-Mailer: Apple Mail (2.3774.400.31) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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/