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

From Thiemo Kellner
Subject Re: Table size is constantly growing and causing performance problems
Date
Msg-id d75be95f-fcb8-45ea-ae65-df5eb35fd7a2@gelassene-pferde.biz
Whole thread Raw
In response to Table size is constantly growing and causing performance problems  (srinivasan s <srinioracledba7@gmail.com>)
List pgsql-admin
Hi

12.02.2025 05:45:36 srinivasan s <srinioracledba7@gmail.com>:

> One of the tables in our database suddenly started  growing very fast without any changes to the environment.

> we are using postgres version 12 on ubuntu

Is there a reason, you stay on v12 when v17 is available?

Are we to understand that the table takes in news rows but also those get deleted in about the same number so only little grow is expected if at all? Does count(*) reflect the size growth? If not did you check your processes for insert/delete? Do they apply/affect the same amount of rows before? Has there popped up an imbalance? I am assuming the processes as in my second question.

Cheers Thiemo

pgsql-admin by date:

Previous
From: srinivasan s
Date:
Subject: Table size is constantly growing and causing performance problems
Next
From: Laurenz Albe
Date:
Subject: Re: Table size is constantly growing and causing performance problems