Firstly, the database will try not to exceed it but is allowed to, so keep enough free space on the partition and monitor it. Note: The max_wal_size is a soft limit for total WAL size, which has two consequences. With these (default) values, PostgreSQL will trigger a CHECKPOINT every 5 minutes, or after the WAL grows to about 1GB on disk. max_wal_size = 1GB (before PostgreSQL 9.5 this was checkpoint_segments).Those time/size limits are set using two configuration options: This blog post is about how to configure the two other events, affecting regular periodic checkpoints. ![]() The first two points are rather irrelevant here – those are rare, manually triggered, events.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |