@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/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
