Re: Table : Bloat grow high

On 11/11/22 11:09, Alexis Zapata wrote:
>
> Hi all,
> In postgresql 13.5

Upgrade to at least 13.8.  (13.9 was released yesterday.)

> I have a table (size 3.1 GB) and in this table occurs near to 200 updates
> per second, after 2 days the size table is 7 GB and bloat grow to 45% and
> the query operations are degraded. vacuum runs every 5 seconds over this.
> but the bloat growth continues, to solve the
> problem quickly, we have made a replica of the table with a trigger, then
> a copy of the data and in a
> transaction we rename the table, but it would not be the best solution.
> Some suggestion about stop this size increase or parameter to setting up?

Manually vacuum it on a regular basis.

Think about partitioning it on PK boundaries; that way you can vacuum each
child at the same time.

--
Angular momentum makes the world go 'round.