Re: Bloated toast table with empty associated table

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Bloated toast table with empty associated table
Дата
Msg-id 4c41f836-ee5c-40ec-9216-b9eeb7102f44@aklaver.com
обсуждение исходный текст
Ответ на Bloated toast table with empty associated table  (Paul Allen <paulcrtool@gmail.com>)
Список 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 по дате отправления: