2013/5/17 Douglas Fabiano Specht <[email protected]> > > Boa tarde Pessoal > seguinte tenho configurado em checkpoint_segments=100 e checkpoint_timeout = 15min > ocorre que ao analisar a pasta pg_xlog, tenho la 203 arquivos de 16mb. > nao deveria de ter apenas 100 no maximo?
Não... veja o que diz um trecho da documentação extraido de [1] "There will always be at least one WAL segment file, and will normally not be more than (2 + checkpoint_completion_target) * checkpoint_segments + 1 or checkpoint_segments +wal_keep_segments + 1 files. Each segment file is normally 16 MB (though this size can be altered when building the server). You can use this to estimate space requirements for WAL. Ordinarily, when old log segment files are no longer needed, they are recycled (renamed to become the next segments in the numbered sequence). If, due to a short-term peak of log output rate, there are more than 3 * checkpoint_segments + 1 segment files, the unneeded segment files will be deleted instead of recycled until the system gets back under this limit." Att, [1] http://www.postgresql.org/docs/current/static/wal-configuration.html -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
