Why does autovacuum: VACUUM ANALYZE (to prevent wraparound) run?
I have an autovacuum VACUUM ANALYZE query running on a table, and it
always takes many hours, even a couple of days to finish. I know Postgres
runs autovacuum jobs occasionally to perform cleanup and maintenance
tasks, and it's necessary. However, most tables simply have an VACUUM, not
a VACUUM ANALYZE.
Why does this specific table require a vacuum analyze, and how can I
resolve the issue of it taking so long?
On a separate note, I did not notice this vacuum analyze query running
before a few days ago. This is when I was attempting to create an index,
and it failed prematurely saying it ran out of open files (or something
like that). Could this contribute to the vacuum analyze running for so
long?
No comments:
Post a Comment