Dushyanth <dushyanth@xxxxxxxxx> 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
