I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🤩 It's so much better now!

This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

#gischat #postgis #pgrouting #pgosm #routing

https://blog.rustprooflabs.com/2025/12/pgosm-flex-pgrouting-performance-quality-improvements

Improved Quality in OpenStreetMap Road Network for pgRouting - Blog @ RustProof Labs

The latest PgOSM Flex image now has osm2pgsql 2.0.0. Here's the quick start if you haven't tried PgOSM Flex yet!

https://pgosm-flex.com/quick-start.html

#pgosm #postgis #openstreetmap #gischat

Quick Start - PgOSM Flex User Guide

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS using the osm2pgsql Flex output

Initial version of Windows instructions for PgOSM Flex are live! Hopefully this helps some folks out there.

https://pgosm-flex.com/windows.html

#pgosm #gischat #postgis #docker #windows

Running on Windows - PgOSM Flex User Guide

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS using the osm2pgsql Flex output

I hadn't tried Docker Desktop on Windows before today. Gotta say... pretty good experience 🤓

Julie is working on new training materials for PgOSM Flex and she wanted to run it on her Windows laptop... so we'll have a section to help Windows users in the user guide soon!! 🎉

#pgosm #docker #postgis

Huge shout out to the osm2pgsql devs! Connection volume to Postgres had gotten a bit awkward with the Flex styles when they're used the way PgOSM Flex does. Replication with the default layerset previously used 207 connections! 🤯

The same step only uses 17 now!! 🎉 (:latest on Docker Hub updated)

Details and before/after charts are in the comments of the PR for the curious 🤓

#postgis #osm2pgsql #postgres #postgresql #gischat #pgosm
https://github.com/rustprooflabs/pgosm-flex/pull/376

Testing osm2pgsql PR #2134 for reducing conections by rustprooflabs · Pull Request #376 · rustprooflabs/pgosm-flex

This PR started by testing osm2pgsql-dev/osm2pgsql#2134. Those results were encouraging and is now this is a PR addressing a couple other minor improvements. Uses latest osm2pgsql, significantly ...

GitHub

pgBouncer is being added to PgOSM Flex! This should help the connection load with --append workloads

It is a WIP but I *think* it is functional! Testing and feedback welcome.

This finally became possible b/c pgBouncer added support for prepared statements 🤓

#pgosm #postgis #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/pull/243

Add pgBouncer to funnel connections by rustprooflabs · Pull Request #243 · rustprooflabs/pgosm-flex

Addresses #236.

GitHub

PgOSM Flex is ready to go with Postgres 16 and PostGIS 3.4! 🤓 🐘 🗺️

#pgosm #postgis #postgres #postgresql #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.2

Release 0.10.2 · rustprooflabs/pgosm-flex

PgOSM Flex 0.10.2 Commit hash: f45b3f6 The commit hash from this git repo shows up with the PgOSM Flex version number in SELECT pgosm_flex_version FROM osm.pgosm_flex; If you see this version wit...

GitHub

PgOSM Flex 0.10.0 is out!

This release adds support to define custom indexing on your tables. 🎉

(Plus some bug fixes 🐛)

#pgosm #postgis #openstreetmap #postgres #postgresql #osm2pgsql

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.0

Release 0.10.0 · rustprooflabs/pgosm-flex

PgOSM Flex 0.10.0 This release contains ⚠️ breaking changes ⚠️. Commit hash: e7d967e The commit hash from this git repo shows up with the PgOSM Flex version number in SELECT pgosm_flex_version FRO...

GitHub

PgOSM Flex 0.9.0 is out! 🎉

Please read the release notes, there are ⚠️ breaking changes ⚠️ to be aware of!

This release continues using more of the newer features available in osm2pgsql

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.9.0

#pgosm #postgis #openstreetmap #gischat

Release 0.9.0 · rustprooflabs/pgosm-flex

PgOSM Flex 0.9.0 This release contains ⚠️ breaking changes ⚠️. The original _all views for the building, shop and POI layers have been replaced by tables. The tables are built via osm2pgsql Flex ...

GitHub

PgOSM Flex 0.8.1 is out! 🤓

Okay, the big news should be that it now attempts to prevent you from hosing your own database...

However, I think the continuous improvements to the docs are more important! Now providing more guidance to decide which method to use to keep your DB updated 👍

https://pgosm-flex.com/data-updates.html

#pgosm #postgis #postgres #openstreetmap

Data updates - PgOSM Flex User Guide

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS using the osm2pgsql Flex output