Olá Amigos !! Na última semana tem aparecido esse tipo de mensagem no log do postgresql, algumas dezenas de linhas. Tenho pesquisado na documentação mas não consegui chegar a uma conclusão. Eu sempre monitoro o servidor e não vejo esgotamento de recursos do mesmo que roda num CentOS. Será algum parametro do postgresql.conf que esta mal calibrado ?
============================ 2015-06-09 22:12:58 AMT [25543]: [65-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-06-09 22:13:01 AMT [25543]: [66-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 28 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=2.710 s, sync=0.007 s, total=2.720 s; sync files=26, longest=0.001 s, average=0.000 s 2015-06-09 22:17:58 AMT [25543]: [67-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-06-09 22:17:59 AMT [25543]: [68-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 14 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=1.305 s, sync=0.004 s, total=1.312 s; sync files=11, longest=0.001 s, average=0.000 s 2015-06-09 22:22:58 AMT [25543]: [69-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-06-09 22:22:59 AMT [25543]: [70-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.603 s, sync=0.002 s, total=0.609 s; sync files=7, longest=0.001 s, average=0.000 s 2015-06-09 22:27:58 AMT [25543]: [71-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-06-09 22:28:00 AMT [25543]: [72-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 26 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=2.508 s, sync=0.008 s, total=2.519 s; sync files=23, longest=0.001 s, average=0.000 s 2015-06-09 22:32:59 AMT [25543]: [73-1] user=,db=,app=,client= LOG: checkpoint starting: time ============================ -- foobar
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
