Willian, bom dia
Como esta o parâmetro de shared buffer com postgresql.conf? WAGNER ROGERIO GARCIA De: pgbr-geral [mailto:[email protected]] Em nome de Willian César Enviada em: quarta-feira, 3 de agosto de 2016 10:05 Para: [email protected] Assunto: [pgbr-geral] Servidor utilizando muita memória Bom dia à todos! Estou realizando um serviço em um cliente que possui um ERP que trabalha com PostgreSQL 9.3. O servidor está virtualizado com Xen e a VM do banco de dados possui 16GB RAM / CentOS 6. Com o comando "free -m" o resultado é: total used free shared buffers cached Mem: 15943 15795 148 3161 52 14104 -/+ buffers/cache: 1638 14305 Swap: 5007 42 4965 Comando "top": Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 0.3%us, 0.7%sy, 0.0%ni, 99.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu8 : 4.7%us, 1.7%sy, 0.0%ni, 75.7%id, 18.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu9 : 25.0%us, 6.1%sy, 0.0%ni, 67.6%id, 0.3%wa, 0.0%hi, 0.7%si, 0.3%st Mem: 16326604k total, 16174792k used, 151812k free, 37652k buffers Swap: 5128188k total, 44252k used, 5083936k free, 14336948k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1983 postgres 20 0 3351m 2.7g 2.7g S 0.0 17.1 1:33.46 postgres: checkpointer process 1984 postgres 20 0 3350m 2.4g 2.4g S 0.3 15.2 0:39.87 postgres: writer process 13753 postgres 20 0 3395m 2.3g 2.3g S 0.0 14.9 5:46.68 postgres: postgres GIX 192.168.0.9(48300) idle Devo aumentar o parâmetro "checkpoint_segments" ? Checkpoint confs: checkpoint_segments = 32 # in logfile segments, min 1, 16MB each checkpoint_timeout = 40min # range 30s-1h checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0 checkpoint_warning = 30s # 0 disables log_checkpoints = on OBS.: a empresa que desenvolve o ERP não possui ninguém capacitado para ajudar. Atenciosamente, Willian César Cincerre da Silva
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
