Jakob Miksch#osm2pgsql got funding to reduce ressource usage 🎉
needed for keeping pace with the every growing amount of #openstreetmap data
#osm #postgis #postgresql
https://osm2pgsql.org/news/2026/04/25/ngi0-grant-for-osm2pgsql.html
good news for #osm2pgsql
the main user of the tool, namely the #OSM foundation, switched to the new "flex" configuration based on #lua
so the "old" way of configuration can be retired
https://osm2pgsql.org/news/2026/04/20/osm-carto-switches-to-flex.html
Amᵃᵖanda#osm2pgsql's flex backend / themepark stuff is pretty cool TBH
#osm2pgsql version 2.2 released with a new "locator" feature and callbacks for deleted objects
#osm #openstreetmap #postgres #postgresql #postgis #gis #geodata
https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.2.0
#osm2pgsql code got some cleanup
#openstreetmap #osm #postgis #postgresql #cpp #gis
https://osm2pgsql.org/news/2025/08/21/zero-warnings.html
#openstreetmap #osm #postgis #postgresql #cpp #gis
https://osm2pgsql.org/news/2025/08/21/zero-warnings.html
Sven GeggusIn case someone is interested. Importing an #Openstreetmap planet file into #postgresql using #osm2pgsql in non-slim mode took me just under 5 hours here and requires a machine with at least 128GB RAM.
#osm2pgsql FAQ:
If you don’t need your database to be updateable and you have enough RAM, use non-slim mode.
Unfortunately it does not tell what "enough" roughly means means.
If you don’t need your database to be updateable and you have enough RAM, use non-slim mode.
Unfortunately it does not tell what "enough" roughly means means.
@isotopp @masek Dealing with #Openstreetmap data I usually have a lot of utf-8 crap *inside* #postgresql string columns. LTR and RTL just came to my mind. #osm2pgsql will likely also support utf-8 in table names and indexes %-/
Marcos DioneThanks to https://botsin.space/@planetpostgresql/113510452678670732 I got importing Europe on my puny rig from some 43h to 14h! I didn't quite used the same numbers because I only have 32GiB and it's also my desktop, and I'm also pretty sure I can reduce some numbers given that I don't import the whole planet.
Planet PostgreSQL (Unofficial) (@[email protected])
Greg Smith: Loading the World! OpenStreetMap Import In Under 4 Hours https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours #postgres #postgresql