PostgreSQL 11 configuration: "checkpoint_segments = 32" ?

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

0 votes

0 answers

1268 views

ANSWER

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
05/31/2021

Just opened an issue on Github: https://github.com/nuxeo/doc.nuxeo.com/issues/84
05/31/2021