Yeah when age(relfrozenxid) goes beyond the limit Postgresql will invoke the autovacuum session to avoid a wraparound issue.. But here that's not the case..
> Hello Experts, > > Is there any possibility for autovacuum to work on a user table if we set > Alter table sometable set (autovacuum_enabled = true) ; even if the > parameter autovacuum = off in Postgresql.conf > > I am using Postgresql 10 on Linux 6.9. > > According to me, it won't work without setting autovacuum = on except > for Template0 database. What is your opinion?
I think you are right, autovacuum won't vacuum and analyze a table without setting autovacuum = on. But PostgreSQL might want to force vacuum if a table is at risk of wraparound.
