tate "idle in transaction"
did not continue.
Thank you all
Best regards
________
De: Alexis Zapata
Enviado: domingo, 13 de noviembre de 2022 9:50 a. m.
Para: Laurenz Albe ;
pgsql-general@lists.postgresql.org
Asunto: RE: Table : Bloat grow high
Hi Laurenz ,
I
Hi Laurenz ,
I found that xmin does not change when running the vacuum.
De: Laurenz Albe
Enviado: sábado, 12 de noviembre de 2022 9:05 a. m.
Para: Alexis Zapata ; pgsql-general@lists.postgresql.org
Asunto: Re: Table : Bloat grow high
On Fri, 2022-11-11 at 17
Hi all,
In postgresql 13.5 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 th