Re: Aggressive vacuum

2025-01-07 Thread Jeff Janes
ng up your system once a week for one hour to gumming it up 3 times a week for 20 minutes each is likely not a real solution. And it might not even do that--you could gum it up 3 times a week for 50 minutes each! Unless you have large swaths of table which become effectively read-only over time, ea

Re: Aggressive vacuum

2025-01-06 Thread Slava Mudry
u should consider upgrading to more recent version. Good luck, -Slava On Thu, Dec 19, 2024 at 5:37 AM Graham Hay wrote: > Can anyone enlighten me on exactly what triggers an "aggressive" > vacuum? I have read the docs multiple times (and watched several > videos!), but the cha

Aggressive vacuum

2024-12-19 Thread Graham Hay
Can anyone enlighten me on exactly what triggers an "aggressive" vacuum? I have read the docs multiple times (and watched several videos!), but the changes I make do not have the expected outcomes; so I'm clearly missing something. https://www.postgresql.org/docs/15/routine-vacuum