work_mem and Maintanance_work_mem are limited to just under 2GB for Windows.

[EraYaN]

Otherwise errors like these are logged:

2021-08-16 10:34:22.229 CEST [5644] LOG:  2097152 kB is outside the valid range for parameter "maintenance_work_mem" (1024 .. 2097151)

[sebastianwebber]

@EraYaN can you confirm which pg version are you using?

[EraYaN]

We are using PG 12 on that sever I believe.

Although I see messages about this on the postgres mailing lists back to 2014, so I think it might be in more than one version.

EDIT: It's defined here:
https://github.com/postgres/postgres/blob/master/src/backend/utils/misc/guc.c#L2430-L2439

And then the actual "INT_MAX/1024"

https://github.com/postgres/postgres/blob/master/src/include/utils/guc.h#L23-L27

Last chnaged in this commit: postgres/postgres@a1b395b

[sebastianwebber]

hey @EraYaN,

I will work on the fix and get back to you!