Re: Bloated toast table with empty associated table - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Bloated toast table with empty associated table
Date
Msg-id 4c41f836-ee5c-40ec-9216-b9eeb7102f44@aklaver.com
Whole thread Raw
In response to Bloated toast table with empty associated table  (Paul Allen <paulcrtool@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID
Next
From: Sebastien Flaesch
Date:
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID