após ativar peguei estas informações no log 2010-06-01 07:59:46.010 BRT 32764 LOG: checkpoints are occurring too frequently (10 seconds apart) 2010-06-01 07:59:46.010 BRT 32764 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2010-06-01 08:00:03.191 BRT 32764 LOG: checkpoints are occurring too frequently (17 seconds apart) 2010-06-01 08:00:03.191 BRT 32764 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2010-06-01 08:02:52.364 BRT 32764 LOG: checkpoints are occurring too frequently (24 seconds apart) 2010-06-01 08:02:52.364 BRT 32764 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2010-06-01 08:32:22.138 BRT 32764 LOG: checkpoint starting: time 2010-06-01 08:35:14.474 BRT 32764 LOG: checkpoint complete: wrote 859 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=172.267 s, sync=0.052 s, total=172.344 s
no postgresql.conf está assim: checkpoint_segments = 16 checkpoint_completion_target = 0.9 # pgtune wizard 2010-02-27 log_checkpoints = on 2010/5/29 Euler Taveira de Oliveira <eu...@timbira.com>: > José Carlos Messias escreveu: >> Como vejo o tempo dos checkpoints? >> > log_checkpoints = on. > > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
