类型: | integer |
默认: | 30 (30s) |
最低限度: | 0 (0s) |
最大: | 2147483647 (2147483647s) |
单元: | seconds (s) |
上下文: | sighup |
重新开始: | false |
如果由于填充WAL段文件导致的检查点之间的间隔低于这个参数表示的时间量,那么就向服务器日志写一个消息(它建议增加max_wal_size的值)。 如果指定值时没有单位,则以秒为单位。默认值是 30 秒(30s
)。零则关闭警告。如果checkpoint_timeout低于checkpoint_warning
,则不会有警告产生。这个参数只能在postgresql.conf文件中或在服务器命令行上设置。
在 StackOverflow
- Postgres: Checkpoints Are Occurring Too Frequently
- how to delete enormously growing pg_xlog while streaming replication?
- Postgres performance issues
- What is the best way to load a massive amount of data into PostgreSQL?
- Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads