Ola pessoal... Qria pedir um help para configurar o vacuum e autovacuum
Servidor Xeon 3.0 dual, 16gb ram 4000 inserts / minuto 2000 updates / minuto Configuracoes atuais vacuum_cost_delay = 200 # 0-1000 milliseconds vacuum_cost_page_hit = 6 # 0-10000 credits vacuum_cost_page_miss = 10 # 0-10000 credits vacuum_cost_page_dirty = 20 # 0-10000 credits vacuum_cost_limit = 100 # 0-10000 credits autovacuum_naptime = 3min # time between autovacuum runs autovacuum_vacuum_threshold = 3000 # min # of tuple updates before vacuum autovacuum_analyze_threshold = 2000 # min # of tuple updates before analyze autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before vacuum autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before analyze autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for autovacuum autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for autovacuum _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
