Re: Wasted Vacuum cycles when OldestXmin is not moving

2023-01-22 Thread Bharath Rupireddy
On Wed, Jan 11, 2023 at 3:16 AM sirisha chamarthi wrote: > > Hi Hackers, > > vacuum is not able to clean up dead tuples when OldestXmin is not moving > (because of a long running transaction or when hot_standby_feedback is > behind). Even though OldestXmin is not moved from the last time it

Wasted Vacuum cycles when OldestXmin is not moving

2023-01-10 Thread sirisha chamarthi
Hi Hackers, vacuum is not able to clean up dead tuples when OldestXmin is not moving (because of a long running transaction or when hot_standby_feedback is behind). Even though OldestXmin is not moved from the last time it checked, it keeps retrying every autovacuum_naptime and wastes CPU cycles