Re: Table size is constantly growing and causing performance problems

Hi Mahesh, I see unique constraint violation errors on the logs, is this
anyway related to the issue that I explained?

On Wed, Feb 12, 2025 at 1:23 PM Mahesh Shetty <maheshetty20(at)gmail(dot)com>
wrote:

> Do you see "duplicate key violations" in the logs ?
>
> Regards,
> Mahesh Shetty
>
>
>
> On Wed, 12 Feb 2025 at 13:13, srinivasan s <srinioracledba7(at)gmail(dot)com>
> wrote:
>
>> Hi Shammat,
>>
>> There were some very old idle sessions waiting for clientread, which we
>> have killed. no idle in transaction for a long time
>>
>>
>> On Wed, Feb 12, 2025 at 1:08 PM <shammat(at)gmx(dot)net> wrote:
>>
>>> srinivasan s schrieb am 12.02.2025 um 05:44:
>>> > One of the tables in our database suddenly started growing very
>>> > fast without any changes to the environment. it has grown over 10GB
>>> > in the last week and this is causing performance issues. We ended up
>>> > adding an index to solve the performance problem but the table
>>> > growth didn't stop. It is growing continuously. we are using
>>> > postgres version 12 on ubuntu
>>> >
>>> > 3. Also noticed that there is a auto vacuum job running on the table
>>> with (to prevent wraparound)
>>>
>>> Do you have any connections with the state "idle in transaction"? They
>>> would prevent (auto) vacuum.
>>>
>>>
>>>
>>>
>>>