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 1tvHyd-0038HV-Pj for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 15:38:35 +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 1tvHyb-003RvE-Uw for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 15:38:33 +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 1tvHyb-003Rup-Jv for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 15:38:33 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tvHyZ-0009ln-0s for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 15:38:33 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.stl.internal (Postfix) with ESMTP id 499C8254013E; Thu, 20 Mar 2025 11:38:29 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Thu, 20 Mar 2025 11:38:29 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1742485109; x=1742571509; bh=OmD+2c5eXzsx3abcTJCzFqBIGR715aU1A6hmcTHi1Vk=; b= FFX0OPtKxn/e8HTQit+dfJsVHosF/4txmNl7BrQO85OKLmQEa2V4932Gm7VN1L2g ZXO2PAkE1WCZua635P8ikjvOq9M+Hg9matcJO9VGC7gPd9N5mMn0uKgPyJsDxo47 pGesQJMnHk73ktKAFLQ8Isen+tROIUyXm5TXPLGEG9hUq+jZ+jn5cFzYswpaeK/D ivPxmfr8ZP6kCh/IelWDYugVlBFdlpP6HoJBqIdEtkA48tHDXL7C7UiLcwdiLarb MabbGrfUMAaKzfieNlMKSAbooujzoqvs4wNGX4Sjyo/vulTojh8E9KDgWnGEbvgx TDSxUEdFIO3YygUvXV2Yrw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1742485109; x=1742571509; bh=O mD+2c5eXzsx3abcTJCzFqBIGR715aU1A6hmcTHi1Vk=; b=UoXT0tdd0tMuWnx+E TG1MDxbkahF4l1HR2InAQ3bspPs3Rwl3XzYnWMpZBJJmJ5cH3VMh00KFUsPoZlcv rp0J6o+epnvkKXcLl624L6Gc8fANOxD6jovTbNaefgZ4sdLWhvnuKu3NNuQBy9fx 7NTPafN8+6YtqJP1Tm+ONvz28bUBP2SCoPiqjFeeD75U66z3Xgvq/mJJ5Eyixz9h hfbZj3+tW1hfUv7Dw2lRPBsGHV+YixbdhhZkmuCJ88JJX9MW8X0a2eYjCTFdrbgU cddEKX5KkrDwTihXES9gHOqUVu3x1H5IojFjaCA+V7gM4OT/WYvrQHKrIDy+Lmas WOjpg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddugeekheelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff ggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghv vghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrf grthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeelkedvleekhedtgfei ffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthht ohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphgruhhltghrthhoohhlse hgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishht shdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 20 Mar 2025 11:38:28 -0400 (EDT) Message-ID: <4c41f836-ee5c-40ec-9216-b9eeb7102f44@aklaver.com> Date: Thu, 20 Mar 2025 08:38:27 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Bloated toast table with empty associated table To: Paul Allen , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/20/25 04:39, Paul Allen wrote: > Hello. > > Problem. > > My backend application attempts unsuccessfully repeatedly to insert the > same ~100 rows with images, and despite table's row count remains 0, > toast table's size is growing up permanently, reaching 100, 200, 300 GB > until it takes all available space. You are going to need to show the complete process you are using as well as the error messages you get in the Postgres log. > > Thanks. Daniil Rozanov > > -- Adrian Klaver adrian.klaver@aklaver.com