Re: Aggressive vacuum

2025-01-07 Thread Jeff Janes
On Thu, Dec 19, 2024 at 8:37 AM Graham Hay wrote: > > > > https://www.postgresql.org/docs/15/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND > > This link is to v15 docs. Is that the version you are actually using? The behavior of this feature has changed (repeatedly) over the years, so this is im

Re: Aggressive vacuum

2025-01-06 Thread Slava Mudry
Hello Graham, I had to deal with "vacuum to prevent wraparound" a few times and it's not fun :( Postgres doc explains it very well.. if you see that nasty thing running on your db, your best options are: 1. manually vacuum freeze the table 2. examine vacuum costs and lower them to make sure the aut