| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Paul Allen <paulcrtool(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Bloated toast table with empty associated table |
| Date: | 2025-03-20 15:38:27 |
| Message-ID: | 4c41f836-ee5c-40ec-9216-b9eeb7102f44@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien Flaesch | 2025-03-20 15:42:39 | Re: After upgrading libpq, the same function(PQftype) call returns a different OID |
| Previous Message | Adrian Klaver | 2025-03-20 15:33:07 | Re: After upgrading libpq, the same function(PQftype) call returns a different OID |