Also, is there a way to estimate the vacuum execution? Something like
explain plan - without actually vacuuming, just to see how it will perform
it - like a degree of parallelism?
On Fri, May 2, 2025 at 10:23 AM Leo wrote:
> I have been working on AWS PostgreSQL RDS for a few years, but st
hour each. The problem comes in for the other 2
indexes - they take 12+ hours each to vacuum:
psql:/home/backup/leo/fws_vacuum.sql:6: INFO: vacuuming
"public.pc_workflowlog"
psql:/home/backup/leo/fws_vacuum.sql:6: INFO: launched 4 parallel vacuum
workers for index vacuuming (planned
