On Sun, Jul 24, 2022, at 1:01 AM, yanliang lei wrote: > pg document is not recorded：maintenance_work_mem can not large than 2GB in > windows。 > > https://www.postgresql.org/docs/14/runtime-config-resource.html > > > > I suggest that：modify maintenance_work_mem parameter description in the pg > documents： > > add maintenance_work_mem parameter size limit in windows platform > > > > if you set maintenance_work_mem large that 2GB in windows platform > > postgresql service can not start。 > > in the windows event viewer ，thare is the following error: > > "ERROR: 3072000 is outside the valid range for parameter > "maintenance_work_mem" (64 .. 2097151) > > > > and the work_mem parameter also has similar problems as above。 > > https://www.postgresql.org/message-id/17895.1315869...@sss.pgh.pa.us > I don't think it is a good practice to document operating system limitations because these limitations may be resolved in later versions of the operating system. In this case, an OS choice (int and long are 32-bit values on 64-bit Windows) imposes a Postgres limitation. The documentation does not mention an upper limit and it also provides a suitable error message. Both are sufficient to provide proper functioning for Postgres. IMO that's a change that someone might be excited to address in the future.
[1] https://docs.microsoft.com/en-us/cpp/build/common-visual-cpp-64-bit-migration-issues?view=msvc-170 -- Euler Taveira EDB https://www.enterprisedb.com/
