Horton

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

Lars Aksel Opsahl <lars.opsahl@nibio.no>

View thread
From: Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
To: "MichaelDBA@sqlexec.com" <michaeldba@sqlexec.com>
Cc: "pgsql-performance@lists.postgresql.org" <pgsql-performance@lists.postgresql.org>
Date: 2024-12-09T13:37:33Z
Lists: pgsql-performance 
________________________________
From: MichaelDBA@sqlexec.com <michaeldba@sqlexec.com>
Sent: Monday, December 9, 2024 2:18 PM
To: Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
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