OpenStreetMap and PostgreSQL
As the largest crowd-sourced map project, OpenStreetMap uses PostgreSQL throughout its stack, and one which we use in unusual ways.
I will be taking you through
- how we run a multi-TB database in a production service accessed by the public 24/7;
- the challenges of schema changes when we have seven different programs using the database, all maintained by different people;
- why we are using PostgreSQL Logical replication to produce the files to let users update their data every minute;
- how PostGIS is used with PostgreSQL by thousands to produce their own maps; and
- what it's like maintaining widely-distributed software which interacts with your PostgreSQL database.
Parts of the work presented have been done by colleagues who are unable to attend pgconf.