Re: Table size is constantly growing and causing performance problems - Mailing list pgsql-admin

From srinivasan s
Subject Re: Table size is constantly growing and causing performance problems
Date
Msg-id CAOEeMcVh45Z900bYn25SHKgsy8SCAJ1hE+Q+jhWSzFU__PuELA@mail.gmail.com
Whole thread Raw
In response to Re: Table size is constantly growing and causing performance problems  (shammat@gmx.net)
Responses Re: Table size is constantly growing and causing performance problems
List pgsql-admin
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@gmx.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.




pgsql-admin by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Table size is constantly growing and causing performance problems
Next
From: Mahesh Shetty
Date:
Subject: Re: Table size is constantly growing and causing performance problems