Re: PostgreSQL and a Catch-22 Issue related to dead rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 


From: MichaelDBA@xxxxxxxxxxx <michaeldba@xxxxxxxxxxx>
Sent: Monday, December 9, 2024 2:18 PM
To: Lars Aksel Opsahl <Lars.Opsahl@xxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: PostgreSQL and a Catch-22 Issue related to dead rows
 
You could always turn off vacuuming at the table level and then resume later
Sent from my iPhone

Hi

I am running without auto vacuuming for those  tables already. 

From the application I trigger analyze and vacuum at certain conditions , but that is not solving the problem related to dead rows.

Thanks.

Lars



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux