Re: Table size is constantly growing and causing performance problems

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.
>
>
>
>
>