Depois de muito tempo, acabou o autovaccum na tabela toast. Mas, seguem parâmetros
SELECT name,setting FROM pg_settings WHERE name ~ '^(auto)?vacuum'; "autovacuum";"on" "autovacuum_analyze_scale_factor";"0.02" "autovacuum_analyze_threshold";"50" "autovacuum_freeze_max_age";"200000000" "autovacuum_max_workers";"10" "autovacuum_naptime";"60" "autovacuum_vacuum_cost_delay";"20" "autovacuum_vacuum_cost_limit";"-1" "autovacuum_vacuum_scale_factor";"0.05" "autovacuum_vacuum_threshold";"50" "vacuum_cost_delay";"0" "vacuum_cost_limit";"200" "vacuum_cost_page_dirty";"20" "vacuum_cost_page_hit";"1" "vacuum_cost_page_miss";"10" "vacuum_defer_cleanup_age";"0" "vacuum_freeze_min_age";"50000000" "vacuum_freeze_table_age";"150000000"
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
