topic Re: PostgreSQL 11 configuration: "checkpoint_segments = 32" ? in Nuxeo Forum

PostgreSQL 11 configuration: "checkpoint_segments = 32" ?

Samuel_VISCAPI — Fri, 30 Apr 2021 13:09:57 GMT

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

Re: PostgreSQL 11 configuration: "checkpoint_segments = 32" ?

Samuel_VISCAPI — Mon, 31 May 2021 15:07:54 GMT

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

Re: PostgreSQL 11 configuration: "checkpoint_segments = 32" ?

Samuel_VISCAPI — Mon, 31 May 2021 15:24:27 GMT

Just opened an issue on Github