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

From shammat@gmx.net
Subject Re: Table size is constantly growing and causing performance problems
Date
Msg-id 2f93346f-645f-46a0-9cad-c913537b5eed@gmx.net
Whole thread Raw
In response to Table size is constantly growing and causing performance problems  (srinivasan s <srinioracledba7@gmail.com>)
Responses Re: Table size is constantly growing and causing performance problems
List pgsql-admin
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: Laurenz Albe
Date:
Subject: Re: Security definer function to alter a sequence
Next
From: srinivasan s
Date:
Subject: Re: Table size is constantly growing and causing performance problems