Solved: Table : Bloat grow high

2022-12-05 Thread Alexis Zapata
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

RE: Table : Bloat grow high

2022-11-13 Thread Alexis Zapata
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

Table : Bloat grow high

2022-11-11 Thread Alexis Zapata
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