Skip to content

Instantly share code, notes, and snippets.

@pnorman

pnorman/pgconf.md

Created January 11, 2024 17:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pnorman/ac8697a4eb4acc9857c2258f70eac624 to your computer and use it in GitHub Desktop.
Save pnorman/ac8697a4eb4acc9857c2258f70eac624 to your computer and use it in GitHub Desktop.
Download ZIP
pgconf.dev 2024 submission
Raw
pgconf.md

Title

OpenStreetMap and PostgreSQL

Abstract

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.

Submission notes

Parts of the work presented have been done by colleagues who are unable to attend pgconf.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment