Hello Folks,
Upgraded our AWX 15.0.1 to 23.9.0.
It was a fresh install with DB migrated separately.
After cleaning up lots of data, the size of DB isn’t decreasing.
See both autovacuum & track_counts are on.
psql -U awx
psql (13.14 (Debian 13.14-1.pgdg120+2))
Type “help” for help.
awx=#
awx=# show autovacuum;
autovacuum
on
(1 row)
awx=# show track_counts;
track_counts
on
(1 row)
Manually changed these settings in “postgresql.conf” as well and restarted AWX.
DB size still remains same even after a week.
Request assistance to figure out the anomaly.