postgresql checkpoints相关参数


2016-10-10 03:04:29 CST [26586-131] LOG:  checkpoints are occurring too frequently (17 seconds apart)
2016-10-10 03:04:29 CST [26586-132] HINT:  Consider increasing the configuration parameter "checkpoint_segments".


[1]PgSQL · 特性分析 · 谈谈checkpoint的调度
[2]PostgreSQL 中 checkpoint 和 WAL 日志量的关系以及优化


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.