Dushyanth <dushyanth(at)gmail(dot)com> writes:
>> Does "show autovacuum" confirm that it's off?
> Yes.
> # show autovacuum;
> autovacuum
> ------------
> off
> (1 row)
Then the only other possibility is that autovacuum is being launched to
prevent XID wraparound. Are there any tables in that database with
particularly old relfrozenxid? Try something like
select relname, age(relfrozenxid) from pg_class
where relkind in ( 'r', 't') order by 2 desc;
regards, tom lane