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

[mboeringa]

> @mboeringa You are on Windows, can you set maintenance_work_mem to more than 1 GB?

Correction: 

I have tested and successfully run the latest Windows build of osm2pgsql  (2.1.1) on Windows 10, but my PostgreSQL database actually runs in a Microsoft Hyper-V virtual machine instance with Ubuntu 24.04 as the guest operating system, that I access from the Windows host where osm2pgsql runs.

So no, with my current setup, I cannot test if there is a specific issue with maintenance_work_mem on PostgreSQL in Windows, but it seems highly unlikely to me. As said, adding some appropriate virtual memory / paging files on Windows might help, but the first course of action is adjusting the PostgreSQL configuration to match the available (RAM) resources of the machine as @ImreSamu pointed out.

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

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