Conference Schedule - PGConf.EU 2022

Inside the machine room of a world map: PostgreSQL and OpenStreetMap

Date: 2022-10-26
Time: 17:20–18:10
Room: Berlin 2+3
Level: Intermediate

The OpenStreetMap (OSM) project is a community project to collect map data of the whole world. Started in 2007 as a small mapping project in the UK, it has become one of the most important providers of geodata. Its database has grown to almost 9 billion objects. OSM has very early on chosen PostgreSQL for the core database of the project and the combination of PostgreSQL and PostGIS turned out to be a perfect match for OSM data users. Nowadays it is hard to avoid PostgreSQL when working with OSM data.

This is the story of how OSM was able to grow into a huge global geo database with the help of the ever maturing PostgreSQL project. The talk will explore three core pieces of software for OSM: the main OSM database, the database loader osm2pgsql and the geocoder Nominatim. We look into how these projects make use of PostgreSQL and how their usage patterns have changed over time. There will be anecdotes of moments where PostgreSQL was at its best and other moments where we found out about its limits.

Speaker

Sarah Hoffmann