[Tile-serving] [osm2pgsql-dev/osm2pgsql] Changing parameter maintenance_work_mem = 10GB results in error Postgresql 17 (Discussion #2375)

[Jochen Topf]

@ImreSamu The example configuration in the manual is for a 128 GB RAM machine, that's right. But that doesn't mean it is wrong for other RAM sizes or that's the reason why setting `maintenance_work_mem` to 10GB does not work.

I simply seems there is a limit to how large `work_mem` and `maintenance_work_mem` can be on Windows. A limit that's not there on Linux. See for instance [here](https://stackoverflow.com/questions/33995367/cannot-increase-work-mem-above-1gb-using-postgresql-9-3-on-windows-server) and [here](https://www.reddit.com/r/PostgreSQL/comments/u17gwb/why_i_cant_set_working_memory_more_than_1gb_it/). I don't know why there is this limit and why it isn't documented in the PostgreSQL manual and whether that's something that depends on the PostgreSQL version.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2375#discussioncomment-14064121
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2375/comments/14064121 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250810/18c10425/attachment.htm>