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 1qzz6x-002S5D-BG for pgsql-general@arkaria.postgresql.org; Mon, 06 Nov 2023 12:53:47 +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 1qzz6v-00FQrc-UP for pgsql-general@arkaria.postgresql.org; Mon, 06 Nov 2023 12:53:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzz6v-00FQrT-HH for pgsql-general@lists.postgresql.org; Mon, 06 Nov 2023 12:53:45 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzz6o-004Eb8-AP for pgsql-general@lists.postgresql.org; Mon, 06 Nov 2023 12:53:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding: Content-ID:Content-Description; bh=ctl6V9akmWOWDH99QUQpWk/AFriOuvWIhO/cGu70Yzw=; b=NCTgUBmr9uGCpqosHgsPZRFuNO y74G1wSNGqB2pK1PRXAmlQxSq+aBhxo0EOk1z5u0aYNYXPPV8dPffnycAD9mci9PvgVZesquG4NJ7 zptlQtORZ0Tgse14XPaC4WvmfuMW/CNWHYFqfKjAPEL7Tm0Uo/Xp0X0buZhfap1RuhRE=; Received: from depesz by depesz.com with local (Exim 4.94.2) (envelope-from ) id 1qzz6l-00DaSi-BL; Mon, 06 Nov 2023 13:53:35 +0100 Date: Mon, 6 Nov 2023 13:53:35 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Gabriel Dodan Cc: pgsql-general@lists.postgresql.org Subject: Re: Postgresql went crazy and flooded all the SSD Message-ID: Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Nov 06, 2023 at 01:11:31PM +0200, Gabriel Dodan wrote: > Not sure exactly what happened but Postgresql flooded all the available SSD > space and obviously crashed. It has written a lot of data in the pg_wal > folder. Most likely it was caused by replication. The postgresql instance > that crashed was a subscriber and publisher at the same time. Even so, it > was not a heavy write replication, I mean the data that needed to be > replicated was rarely updated. Has anyone else encountered such an issue? You might want to read https://www.depesz.com/2023/06/18/why-is-my-wal-directory-so-large/ Best regards, depesz