PostgreSQL 11 configuration: "checkpoint_segments = 32" ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2021 09:09 AM
Dear all,
A simple question regarding PostgreSQL 11 setup with Nuxeo 2019 LTS:
https://doc.nuxeo.com/nxdoc/1010/postgresql/#buffering-writes
The documentation states, for both PostgreSQL 9.6 and 11:
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target=0.8
But if I understand correctly, "checkpoint_segments" are deprecated since PostgreSQL 9.4. When I add this option to my PostgreSQL 11 configuration file, the service refuses to start.
What am I doing wrong ?
Best regards,
Samuel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2021 11:07 AM
Dear all. Would you have any news regarding this issue ? I understand the correct parameter would be "max_wal_size" now, but how would you use this properly for Nuxeo ? Best regards, Samuel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2021 11:24 AM
Just opened an issue on Github
