I'm concerned that Autovacuum may not be running based on the results of this query.
SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables; gives 211 rows like this... *relname | last_vacuum | last_autovacuum*BusinessIncidentCategories | null | null Valid Use | null | null Serial Pool Part Types | null | null BusinessIncidentLog | null | null Rate Categories | null | null I don't see any process with 'auto' or 'vacuum' in the name in TaskManager. I don't see anything similar set up in Services to run in the background. I do see pg_ctl running for each instance of the server running, 9.4 and 14. The settings look ok as far as I can tell. SELECT name, setting FROM pg_settings WHERE name='autovacuum'; name | setting autovacuum | on SELECT name, setting FROM pg_settings WHERE name='track_counts'; name | setting track_counts | on SELECT relname, reloptions FROM pg_class; These are not turned OFF, and I assume the default is ON. *relname | reloptions* pg_statistic | null pg_type | null Activity Codes | null Activity Codes_ID_seq | null ...... SELECT * from pg_settings where category like 'Autovacuum'; autovacuum on Autovacuum Starts the autovacuum subprocess. sighup bool default on on autovacuum_analyze_scale_factor 0.1 Autovacuum Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. sighup real default 0 100 0.1 0.1 autovacuum_analyze_threshold 50 Autovacuum Minimum number of tuple inserts, updates, or deletes prior to analyze. sighup integer default 0 2.15E+09 50 50 autovacuum_freeze_max_age 2E+08 Autovacuum Age at which to autovacuum a table to prevent transaction ID wraparound. postmaster integer default 1E+08 2E+09 2E+08 2E+08 autovacuum_max_workers 3 Autovacuum Sets the maximum number of simultaneously running autovacuum worker processes. postmaster integer default 1 8388607 3 3 autovacuum_multixact_freeze_max_age 4E+08 Autovacuum Multixact age at which to autovacuum a table to prevent multixact wraparound. postmaster integer default 10000000 2E+09 4E+08 4E+08 autovacuum_naptime 60 s Autovacuum Time to sleep between autovacuum runs. sighup integer default 1 2147483 60 60 autovacuum_vacuum_cost_delay 20 ms Autovacuum Vacuum cost delay in milliseconds, for autovacuum. sighup integer default -1 100 20 20 autovacuum_vacuum_cost_limit -1 Autovacuum Vacuum cost amount available before napping, for autovacuum. sighup integer default -1 10000 -1 -1 autovacuum_vacuum_scale_factor 0.2 Autovacuum Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. sighup real default 0 100 0.2 0.2 autovacuum_vacuum_threshold 50 Autovacuum Minimum number of tuple updates or deletes prior to vacuum. sighup integer default 0 2.15E+09 50 50
