| From: | Mahesh Shetty <maheshetty20(at)gmail(dot)com> |
|---|---|
| To: | srinivasan s <srinioracledba7(at)gmail(dot)com> |
| Cc: | shammat(at)gmx(dot)net, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Table size is constantly growing and causing performance problems |
| Date: | 2025-02-12 07:53:46 |
| Message-ID: | CAJPiW+iM0Kua9G79AELF287Zpp8=dPEirV2OnaJ5GeRVcYvUJw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
>>
>>
>>
>>
>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | srinivasan s | 2025-02-12 08:12:24 | Re: Table size is constantly growing and causing performance problems |
| Previous Message | srinivasan s | 2025-02-12 07:43:24 | Re: Table size is constantly growing and causing performance problems |