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
