Настройка автовакуума #
ALTER SYSTEM SET autovacuum_vacuum_scale_factor = 0.01;
ALTER SYSTEM SET autovacuum_analyze_scale_factor = 0.02;
ALTER SYSTEM SET autovacuum_max_workers = 5;
SELECT pg_reload_conf();
Просмотр текущей статистики автовакуума #
select relname,last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables;
SELECT * from pg_settings where category like 'Autovacuum';